• 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: