Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 2: Writing Subqueries RE: Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 2: Writing Subqueries

  • December 23, 2014 at 8:27 am

    #1766210

    lara.krefski (3/6/2014)

    The example for Listing 6 is wrong. It has the same query as listing 5. Please correct it.

    I think the author meant something like:

    Select

    OrderDate,

    DateDiff(day,OrderDate,(Select MAX(OrderDate) from Sales.SalesOrderHeader)) 'Days to Max OrderDate',

    (Select MAX(OrderDate) from Sales.SalesOrderHeader) 'Max Order Date'

    from Sales.SalesOrderHeader