I have a table that has a column called "Control". This is a nvarchar(25) data type. I want to write a stored procedure that will copy the latest record into a new record and add a "-xx" value. For example:
A call to the SP would yield all of the data from Control 'A1234' and create a new record with 'A1234-1'
A subsequent call would yield 'A1234-2', etc.
Been struggling with this for awhile and its very urgent. Thank you.