Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 copying rows and putting at the end of the table

Author  Topic 

cjhardie
Yak Posting Veteran

58 Posts

Posted - 2007-02-05 : 15:52:56
I want to copy a row from TableA which has 3 columns: cID, ad, notes
and place it at the end of the table with a new cID (we will call it @cID)

Then I want to copy a row from TableB which has 3 columns: bID, cID, extra
where TableA.cID = TableB.cID
and place it at the end of the table with the same @cID


any help would be great

Kristen
Test

22859 Posts

Posted - 2007-02-05 : 23:32:58
Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78593
Go to Top of Page
   

- Advertisement -