Hello All,

  As u know, If we use INTO clause using SELECT then, we can create new table.. But what if everytime, I want to selecet particular records and want to store in same table, then I must override tha table everytime, Does anyone know, how can we write query with SELECT clause that, everytime It should create same table name and also it should override with same or different data..

  Thanks..


~~Dev~~

__________________
~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~

You would have to check if the table exists first, if it does, drop it, then execute your new select into statement.

hello jbenson001

  First of all, thanks for the idea, but Sir, could u tell me the query, i am sure that everytime table will be exists.. so how can we write such a single query, which can not only check but also it table exits, drop it and override it..

   Waiting for the reply..


~~Dev~~

   What do you mean "override"? Do you want to simply just continue to Insert Rows to the table if it already exists? If that is the case, if the table already exists, you CANNOT use Select Into. You will need to use an Insert Into.

Jim

Hye J.Benson,

   First of all, let me tell u Sir, that, I don't want to continuing INSERTing records in table if it is exist..

   Let me clear this time, In my VB application, everytime when it will run, from my table (say it has 10 records), it is going to display on first maximum 5 records.. got it? So,what's happening that table is updating constantly, so, what i want to do is, everytime when i run my VB application, it should display only first 5 maximum records, whether table has only 5 records or 50 records..

  I have just used following query, right now, which can create table one time, but not for everytime.. got it? SO, please suggest me some query, which can override that same table eveytime when i run my VB applilcation..

==============================================
  SELECT TOP 5 buyers INTO top_buy FROM trade ORDER BY buyers DESC
==============================================

  Here, I am displaying top 5 buyers from table called "trade" and everytime, when I could run my VB application the overriding table could be "top_buy"..

  Hope, I have cleared the picture now..



~~Dev~~

I would create a stored procedure. From there you can use the if...exits command to check if the table exists:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[top_buy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[top_buy]
GO

--Then do your insert here ...

Thanks J.Benson..

   Its working, keep in touch..




                                            ~~Dev~~

Glad it is working :)

Jim