Post reply

Grouping & Group by

  • December 6, 2007 at 4:53 pm

    #757914

    [Code]

    SELECT CASE WHEN Total = 1 THEN 'TOTAL' ELSE CONVERT(varchar(10), YearMonthDay) END, Sales

    FROM (

    SELECT YMDH/100 AS YearMonthDay, GROUPING(MySourceTable.YMDH/100) AS Total,

    CONVERT(varchar(30), convert(money, SUM(Sales)),1) AS Sales

    From MySourceTable

    GROUP BY YMDH/100 WITH ROLLUP

    ) DT

    [/Code]

    _____________
    Code for TallyGenerator

  • December 7, 2007 at 7:17 am

    #758068

    Your awesome dude -- Thanks sooooo much!!!

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

You must be logged in to reply to this topic. Login to reply