Home Forums SQL Server 2008 SQL Server 2008 - General Function - Spilt Columns into multiple rows RE: Function - Spilt Columns into multiple rows

  • October 22, 2012 at 2:42 pm

    #1551642

    actually sounds more like an unpivot to normalize a data structure.

    http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx at the very bottom is the unpivot

    EDIT Forgot url tags

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]