Home Forums SQL Server 2008 T-SQL (SS2K8) Multiples address lines on a single row. Pivot? RE: Multiples address lines on a single row. Pivot?

  • February 6, 2014 at 5:29 am

    #1686541

    What I want is this:

    RowID, 1stAddr1, 1stAddr2, 1stAddr3, 1stAddr4, 1stPostcode, 2ndAddr1, 2ndAddr2, 2ndAddr3 (etc)

    If you need just two columns: RowId and ConcatenatedAddress - use advised FOR XML with STUFF thingy.

    If you really want what you have asked - pivotted multiple address columns - you need dynamic cross-tab. Here the one from J.Moden to help:

    http://www.sqlservercentral.com/articles/Crosstab/65048/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]