Home Forums SQL Server 7,2000 T-SQL TRICKY SQL QUERY RE: TRICKY SQL QUERY

  • June 15, 2010 at 2:27 am

    #1180252

    Garadin (6/14/2010)

    Martin,

    Chris was suggesting this book:

    http://www.amazon.co.uk/Microsoft-SQL-Server-2008-Dummies/dp/0470224657 You can pick it up online. You can also get all of the books I listed on Amazon.

    The Understanding and using APPLY (I) link is part of Chris' signature and not directly related to your question.

    Many thanks Seth, I missed this one yesterday.

    Must admit I recommended the SQL for Dummies book without reading all of it, but it looks pretty good. The Excel, Statistics and Word equivalents have helped my better half no end.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden