How to Get the OUTPUT of a column on DELETE where the column you want is in the FK cascading table

• adam spencer

  Hall of Fame

  Points: 3926

  More actions

  February 7, 2011 at 1:55 pm

  #99544

  I have a table tblBatch that has a PK FK relationship (Cascading Delete) on tblSubmissionHistory.

  When I delete from tbl batch is it possible, if so how to get the Output column from tblSubmissionHistory.

  Is there somehting like?

  Delete from tblBatch

  output.delete.tblSubmissionHistory.submissionID into #DeletedSubmissionIDs

  where batchID = 46653

  Thanks!

• rVadim

  Hall of Fame

  Points: 3969

  More actions

  February 8, 2011 at 4:01 pm

  #1284119

  See http://technet.microsoft.com/en-us/library/ms177564.aspx

  --Vadim R.