Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: SQL - Derived Tables

    daninmanchester (1/16/2008)

    pain_killer , the point about NOT using the Year() function is that it will make better use of any index.

    Sorry, my english is very poor, and sometimes I don't...

    January 16, 2008 at 5:43 am

    #768576

  • RE: SQL - Derived Tables

    David A. Long (1/16/2008)

    Great article.

    BTW here id the fix for the original query:

    SELECT C.CustomerID, C.CompanyName

    , COUNT(O.OrderID) AS TotalOrders

    FROM Customers C

    LEFT OUTER JOIN Orders O ON...

    January 16, 2008 at 2:34 am

    #768509

Viewing 2 posts - 1 through 2 (of 2 total)