Sean Lange (4/19/2013)
You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think you could probably turn this whole thing into a MERGE with OUTPUT.
Actually this script I write to create a STNNo which will I used to insert in a column value with another stored procedure...
How can I achieve this thing?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/