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

  • February 1, 2014 at 5:43 am

    #1685286

    I think the code of Listing 5 and Listing 6 is mixed.

    QUOTE

    Example of using a Subquery in a Function Call

    To demonstrate using a subquery in a function call, suppose that you have the requirement to display the number of days between the OrderDate and the maximum OrderDate for each Sales.SalesOrderHeader records.

    The code in Listing 6 meets this requirement.

    SELECT count(*), OrderDate

    FROM [Sales].[SalesOrderHeader]

    GROUP BY OrderDate

    HAVING count(*) >

    (SELECT count(*)

    FROM [Sales].[SalesOrderHeader]

    WHERE OrderDate = '2006-05-01 00:00:00.000');

    Listing 6: Subquery in function call

    The code in Listing 6 has two different subqueries. Both subqueries return the max OrderDate in the Sales.SalesOrderHeader table.

    But the first subquery is used to pass a date to the second parameter of the DATEDIFF function.

    Please correct Listing 6