>>No, SET it was my mistake (copy and paste).
>>Put SET before every variable.
>
>I see now. I understand that you prefer multiple lines. But if I use my syntax (SELECT...) I can put it all in one line. I am just trying to make my stored procedure, where I have to initialized tons of variable to a empty string, shorter (fewer lines so that it would be easier to read). Do you see anything wrong with this SELECT of multiple variables?
Dmitry,
I believe your way is a very good way and this is what I use myself. If I can set them all at once, I do it.
If it's not broken, fix it until it is.
My Blog