I have a stored proc that is using ROW_NUMBER to generate a specific sequence. Based on the last # generated, I need to use this # as a seed value in another stored proc to continue the sequence.
Is it possible to insert the last row number generated into a table? Is there a more elegant solution to this?
Thanks in advance!