Home Forums SQL Server 7,2000 T-SQL Dynamic Query/sproc RE: Dynamic Query/sproc

  • May 8, 2010 at 4:46 am

    #1164545

    alex abenitez (5/5/2010)

    I don't know how many fields it will be but I expect it to be less than 30.

    Did you have the time to read the articles I mentioned in my first reply? Seems to be that DynamicCrossTab is the way to go.

    Or, alternatively, do it in the application layer.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]