copying records

• Taj

  Mr or Mrs. 500

  Points: 596

  More actions

  January 7, 2005 at 9:02 am

  #164263

  I am trying to write a store procedure to copy all records from table A to table B where they are below than a certain date.

  Any help in script writing will be apprecitad.

  Thanks

   

   

  
  Tajammal Butt

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  January 7, 2005 at 9:17 am

  #536471

  select * into tableB from tablea where date < ''

   --if you don't have tableb created

  Insert into tableb select * from tablea where data < ''

  -- If tableb already exists.