here's my query:

SELECT     TOP 100 PERCENT ITEMNMBR, trxloctn, SUM(CASE WHEN datediff(month, docdate, getdate()) = 0 THEN TRXQTY ELSE 0 END) AS period1,

                      SUM(CASE WHEN datediff(month, docdate, getdate()) = 1...

Thanks Jeff for that reply, it's really helpful

Oh I see, thanks for the reply Ninja, I just started working with views, so i'm new to this

Jeff, Actually the sort sentence was just to "debug" the view.

Thanks for your tip, but could you explain why is it such a bad idea?

Thanks ninja, it did work