Instead of RETURN I have added a SELECT @pSTN statement for the different different conditions and its working 🙂
Is it correct?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/