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 4:37 pm

    #1649529

    Erland Sommarskog (9/11/2013)

    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.

    Are you sure? CROSS JOIN shows an error because it can't referenciate n1, n2 and n3.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2