I have a stored procedure that is adding muliple records when it is runs.
What I want to do is build a work file with the Scope_Identity() 'key" of each record I add.
Well for one of the tranactions.
I do have 3 tranacations in this stored procedure
1) delete all records in a work table
2) insert all records
So when this runs it usually adds 30/40 records a run. I want to build in another work table with the Scope_Identity() = key of record added.
3) add comment records