vasuarjula (6/2/2014)

---

Hi,

I have a procedure (a) where i call another procedure (b) passing @message as a parameter to procedure B.

Ex:

Create procedure a

as

Begin

declare @prevyear

exec b @message = 'avvasdva' + cast(@prevyear as varchar)

End

When i execute above procedure, i get error at + sign i.e. @message parameter. how can i concatenate string with another parameter when passing parameters