Home Forums SQL Server 2008 SQL Server 2008 - General csv unpivot WITH identifying column RE: csv unpivot WITH identifying column

  • January 13, 2011 at 2:38 pm

    #1273295

    LutzM (1/13/2011)

    Expanding Waynes code:

    Thanks Lutz!

    @dandenson - in the first post, you had your expected results encased in single quotes; in your subsequent post you took them out. That whole replace function is because you originally specified it. If you don't want them encased in single-quotes, then change the entire replace function with simply "CTE2.Item".

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2