How to dynamically generate a variable name? 1

[lalapaul]

Hi,

I need to dynamically generate a set of variable names. The name of these variable are the values generated by a query. Thanks.

 

[twifosp]

I might need a little more information based on what you'll be selecting into it... but I think this is what you're looking for.

declare @var_gen varchar(1000)
declare @sql varchar(5000)

set @var_gen = (select 'variable')-- from your_query)

set @sql = ('
declare @' + @var_gen + ' varchar(100)

set @variable = ''test''
print @variable
')

print @sql
exec(@sql)

Does that make sense? If not, post more about your query and how you'll be deciding on the variable names and I'll try to help more.