Home Forums SQL Server 2008 T-SQL (SS2K8) T-SQL Pivot Question RE: T-SQL Pivot Question

  • July 24, 2014 at 3:05 pm

    #1732211

    Alan.B (7/24/2014)

    Luis Cazares (2/11/2014)

    Have you tested again?

    Luis - I completely flaked out and missed this message. I am truly sorry and feel like a jerk. I fixed the my code and re-tested it. The server I originally tested this on does not exist. On my laptop (4 cpu, 16gb ram, SQL 2014) using the code that I posted above I get the following results against 10M rows:

    Hey, don't feel that way. It's completely understandable that we can't be here all the time and miss some questions.

    Thank you for sharing.

    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