Summary [Monthly Records] - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

Summary [Monthly Records]

Author

Topic

marcusn25
Yak Posting Veteran

56 Posts

Posted - 2013-09-17 : 06:42:53

--Hello

--I need help in creating summary of monthly records {Feb >> Jan}
-- This should be able to display different years based on date parameter picked
--Month Feb Mar >> Oct Nov >> Jan (different year)
--AMount 512 100 200 245 >> 50

Select
o.Amount,
O.OrdeDate,
Case when month(O.OrderDate) = 0 then o.amount
Else '0'
END AS January,
Case when month (O.OrderDate) =1 Then o.amount
Else '0'
END As February,
Case When month (O.OrderDate) = 2 then o.amount
Else '0'
End as March,
Case When month (O.OrderDate) = 3 THEN o.amount
Else '0'
End as April,
E.T.C >>>>> TO Jan (Following Years)

FROM Orders as O

--Many Thanks

M. Ncube

robvolk
Most Valuable Yak

15732 Posts

Posted - 2013-09-17 : 07:45:54

Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=188259

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources