Hi there i need to pass the data in table1 into table2 and delete the same data in table1.

i need this to happend in buttonclick event and i have to use the Where Close.

the tables have the same data type and columns
i use vb SQL 2005 and VS 2005

any help apprisiated

__________________
bx

Is this a homework assignment? (because of the "I have to use a WHERE clause"?

If so, you're better off posting here: http://p2p.wrox.com/need-help-your-homework-248/

To solve this problem, look in the Books On Line (BOL) of SQL Server for "INSERT INTO" and "DELETE"; they allow you to copy data from one table to another, and then delete the old records.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Hi Imar this is not a homework assignment,
i have posted something else this morning under Begin Aspnet 2.0 Basic, if u can have a look that will be great

thanks

__________________
bx