The OUTPUT Clause for UPDATE Statements

• amarreddy23

  Ten Centuries

  Points: 1361

  More actions

  June 6, 2017 at 12:04 am

  #343099

  Comments posted to this topic are about the item The OUTPUT Clause for UPDATE Statements

  Thanks,
  AMAR
  amarreddy23@gmail.com

• wasay_76

  SSC-Addicted

  Points: 471

  More actions

  June 6, 2017 at 7:51 am

  #1945602

  A Type3 Dimension change can easily be achieved by doing following

  Update [Department_Type3]Set [GroupName_current]='IT',  EffectiveDate=Getdate(),  [GroupName_Old]= [GroupName_current] 🙂