>>>>>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.
>>
>>Thank you for confirming this.
>
>Perf nut in me agrees with one statement to execute,
>but break up into multiple editor lines: they will still exec as one statement.
I was not looking for improving the speed of execution. My only goal in combining many lines into one for making the stored procedure smaller.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham