Sergiy (5/6/2013)

---

kapil_kk (5/6/2013)

---

Instead of RETURN I have added a SELECT @pSTN statement for the different different conditions and its working 🙂

Is it correct?

Yes, it is correct.

In fact, "RETURN @pSTN " was incorrect.

In procedures RETURN_VALUE by default contains error code generated by procedure execution (0 if there is no error).

You may overturn the default value with some other code, but it's vedry not-recommended practice.

RETURN as you used it must be used in scalar functions only.