Home Forums SQL Server 7,2000 T-SQL Adding selects RE: Adding selects

  • August 18, 2003 at 7:20 am

    #470261

    And add the date to that solution to yield

    

    SELECT item_no, date, sum(qty)

    FROM table

    GROUP BY item_no, date