03-15-2012 03:00 PM
I stuck at one place where i am getting remerging note like this -
NOTE: The query requires remerging summary statistics back with the original data.
You can view the data in attachment and syntax below
Here year function is not working in where clause.
selecta.orderid,sum(b.UnitPrice * b.Quantity) as
andyear(orderdate) = 1996
Need further help from the community? Please ask a new question.