My code currently is writing to a table in a stored procedure. The stored procedure should call another stored procedure that then makes a single line of output, however the current stored procedure draws additional data not used in the second stored procedure which I also want to include in the write.
Below is a code snippet, here I use the insert into statement with the stored procedure. This part works, however I wish to add on to the end of that line a single variable value.
Any help on how to get that variable put on the end would help. Note that I can't merely use an update to do it because there isn't a uid, or rather, the uid would be this variable I'm trying to add.
insert into tat_output exec sp_findtesttatcert @mindate,@maxdate,@currenttime,@currentdate,@orderdet,@ordertest,@testsite,@orderloc,@orderphy,@orderpri,@timedatetype,@pattype,@clientcode