I would like to do the following without using cursors. Is it possible?
If there was 1 row I would do the following
Select @variable = Field_Name from Table Where ID = 5
But what is the best way to accomplish the following
(syntax obviously won't work but it demonstrates the issue)
Select @variable = Field_Name from Table Where ID IN (5,6,7)
The goal is to have @variable = Value1, Value2, Value3 so I can use the concatenated string later in the procedure