I am trying to write an SP but stucked. in a situation I am trying to set sub_serial_no and for that I have written
SET @sub_serial_no = (exec GetSubmissionSerialNumber 1)
if I execute only exec GetSubmissionSerialNumber 1 then I am getting the value but when I run the above sp it shows me.
I want to set @sub_serial_no by calling the earlier sp (GetSubmissionSerialNumber)
How do I set that?