Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: The CTE Problem

    Adding the proper column names in parentheses after the CTE name, would equally correct the CTE, so I think both of those answers are technically correct...

    ;WITH MonthlyProductSales(YearMonth,ProductID,SumLineTotal) AS

    (

    SELECT CONVERT(CHAR(7),ModifiedDate,120)

    , ProductID

    ,...

Viewing post 1 (of 1 total)