Thanks for your reply also.
I didn't do a very good job setting this up. I just tried to create a quick example to ask about a concept - Is it possible to loop through multiple variables in a single statement. In my production project, the values don't exist and I use the variables to print them into a row for a business process need.
A table called x has these values in a Prog column: 1, 2, 3, 4
What I want to do is pass each of those variables in the below statement:
insert into q (resultcolumn)
select @prog
from a
and the results in resultcolumn is:
1
2
3
4
This would keep me from declaring and setting the value for @prog 4 times (one for each of the numbers). Does that make sense?