Move records to another table

• Senthilkumar-215205

  SSC Veteran

  Points: 274

  More actions

  June 9, 2005 at 4:00 am

  #186256

  Hi,

  I am a beginer in SQL server. I have created a Customer Service database wherein i maintain tables for Service Contracts and visits made in the contract period. After a defined time period, the contract comes to an end. Within this period, certain visits are made for this contract. After the expiry of the contract, i want to move this data to another table.

   

  How do i do this.

  kesk

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  June 9, 2005 at 4:04 am

  #564131

  Use INSERT INTO ... SELECT to move the data and thereafter DELETE. Both syntax are explained in BOL.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]