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