putting values into variables

[ecannizzo]

I know this is doable:

select @MyVariable = ColumnName from MyTable where MyId = SomeInteger

Can you do it with multiple outputs? Something like this:

select @MyVariable1, @MyVariable2 = ColumnName1, ColumnName2 from MyTable where MyId = SomeInteger

Thanks!

 

[gmmastros]

Read this: thread183-1420441

Does that answer your question?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[ecannizzo]

Yes, thanks!