Home Forums SQL Server 2005 T-SQL (SS2K5) Pivot with dynamic number of columns RE: Pivot with dynamic number of columns

  • January 12, 2011 at 2:52 pm

    #1272677

    lduvall (1/12/2011)

    Awesome! Yes, both of these help me tremendously! Thank you so much!

    I've been wanting to learn about the STUFF syntax, too. I'm going to dive into both of these examples and figure this out.

    I really appreciate that you took the time to use my example. It's beginning to click now.

    Excellent!!

    There are people simply copying the code and be happy a single issue has been resolved.

    And there are people like you who just need a few lines of code for a general concept to "click". The latter makes it all worth the effort...

    Edit: you might want to have a look at this article[/url] covering the comma separated list issue...


    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]