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

  • January 29, 2014 at 11:40 am

    #1684445

    Thank you for the article. I'm not getting any results from either of the queries in listing 1. Sorry if I missed something here.

    SELECT ROW_NUMBER() OVER (ORDER BY SalesOrderID) RowNumber

    , (SELECT COUNT(*)

    FROM [Sales].[SalesOrderHeader]

    WHERE ModifiedDate = '2007-02-19 00:00:00.000')

    AS TotalOrders

    , *

    FROM [Sales].[SalesOrderHeader]

    WHERE OrderDate = '2007-02-19 00:00:00.000';

    or

    SELECT COUNT(*)

    FROM [Sales].[SalesOrderHeader]

    WHERE OrderDate = '2007-02-19 00:00:00.000'