Trigger for inserting record in another table

• mimo82

  Grasshopper

  Points: 16

  More actions

  January 26, 2009 at 5:51 am

  #155175

  Dear all

  I need a solution for this

  I have two tables one is Current Emp [ T1 ] and the other is Previous emp [ T2 ] , So I need a trigger that will delete the record from the T1 table and inserted to the T2 table ?

  >> I hope it's clear <<

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  January 26, 2009 at 6:07 am

  #932546

  please don't cross-post.

  http://www.sqlservercentral.com/Forums/Topic643362-146-1.aspx