gsd1 (10/29/2012)
Hello Friends.What is the best way of creating table variable dynamically?
Thanks & Regards,
that's a good one.. creating dynamic variable dynamically...:-P
you might be able to create the table variable dynamically , but i don't think you would be able to use it ;
even if you use dynamic sql to do that , i think that execution would be the life of table variable..
for your requirement , i think this should work..
select column_name into temptable
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: