• L' Eomot Inversé (12/6/2011)


    It's another one where I'm surprised by the failure rate - 78% wrong answers is amazing. Does that mean that 78% of people here never write or read complex queries?

    I don't find it all that surprising, Tom. It seems like most of the stuff I'm fixing every day is because once it gets beyond a simple query, a c.u.r.s.o.r is used. Personally, I'm pleased that it's this high.

    Hugo - excellent question. I'm thoroughly enjoying these questions you've been posting.

    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