variables in a table name

[thminer]

i am trying to figure out if naming a table with a declared variable is possible. i have a stored procedure that runs one time a week. when i run the sproc, i enter a variable known as @weeknumber. i would like the result set to write to a table with the name of the @weeknumber variable. for example, if i declare @weeknumber = 37, i would like the results written to tblweek37. is this possible?
thanks

 

[SQLDenis]

yes use dynamic SQL

declare @FilterString int
set @FilterString = 37

declare @sql varchar (500)
select @sql ='insert into Table' + convert(varchar,@FilterString) + ' select * from temptable'

print (@sql) --testing
exec (@sql)




Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/