Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How do I convert column data into row data? RE: How do I convert column data into row data?

  • September 11, 2013 at 3:53 pm

    #1649519

    ChrisM@Work (9/4/2013)

    Or CROSS APPLY VALUES

    Somewhat odd to use CROSS APPLY here. The normal is CROSS JOIN. Of course since there is no correlation on the right side, the CROSS APPLU is effectively a CROSS JOIN, but nevertheless.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]