Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mcAmri/sqlserver2005forsql2kdeveloperpart1.asp
Clean and clear demonstration of such a useful feature...
I look forward to more...thanks!
Thanks for the examples. In case anyone is working through them, the case statement has a typo with a '2002' replaced with a '2001'
Thankyou I found your article very helpful and presented in a clear style. I look forward to reading more of your work
thanks for the correction of the typo.
The query still works fine, but order year 2001 will be interpreted as 2002 .
It should be like this:
SUM(CASE when OrderYear = 2002 then SubTotal ELSE 0 end) as '2002',
i look farward for more. thanks !
I'm working on second installment of this series now. Just wait
Good intro. Thanks.
I've got a question, though. Given this statement from your article:
INSERT INTO SalesByPerson
SELECT SalesPersonID, ,, FROM Sales.SalesSummarry
PIVOT(SUM(SubTotal) FOR OrderYear IN
(,,)) as SalesPivot
is the IN (.....) required? What if I don't know the values and/or the values change? Am I stuck with dynamic SQL? Could I maybe put a sub-query (i.e. select DISTINCT OrderYear) in there?
Viewing 9 posts - 1 through 8 (of 8 total)