911 - Cursor killing my trigger

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 29, 2009 at 11:41 am

  #1017021

  Curious, but shouldn't this:

  DECLARE noteID_curs CURSOR FOR

  Select NoteID from BugNotes where BugID=@IncidentID and ProjectID=@ProjectID

  come after this:

  Select @ProjectID = (Select ProjectID from Inserted)

  Select @IncidentID = (Select BugID from Inserted)

  ??