I started out writing something to the effect of it being mighty difficult but I thought I'd try the simple approach. The problem is, of course, what happens when they...

You'd then need to insert the results from the view (in the order you need) into a temporary table or a table variable that has an identity column, and then...

You were almost there!

CREATE PROCEDURE [Dbo].[RFG_Mng_Prod_Update] 
 @ProdId VARCHAR(5)='0',
 @Osid  VARCHAR(5)='0',
...

The last time I had to do it, I actually blew the egg rather than sucked it. It was a swan's egg that was highly addled. One drills a hole...