View Single Post
  #2 (permalink)  
Old February 27th, 2009, 05:25 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

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!