how i can get records for month wise records
ex....
Jan Feb Mar April May June July Aug Sep Oct Nov Dec
23 23 22 21 44 12 32 64 45 54 543 434
that way for using count function
but i have already get records for month wise and its working poperlly but when no records avaliable then that time its gives error message
i am using SUM Function in sql server
and i have also share the code.
SELECT
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 1 THEN 1 ELSE 0 END) AS 'January',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 2 THEN 1 ELSE 0 END) AS 'February',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 3 THEN 1 ELSE 0 END) AS 'March',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 4 THEN 1 ELSE 0 END) AS 'April',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 5 THEN 1 ELSE 0 END) AS 'May',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 6 THEN 1 ELSE 0 END) AS 'June',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 7 THEN 1 ELSE 0 END) AS 'July',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 8 THEN 1 ELSE 0 END) AS 'August',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 9 THEN 1 ELSE 0 END) AS 'September',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 10 THEN 1 ELSE 0 END) AS 'October',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 11 THEN 1 ELSE 0 END) AS 'November',
SUM(CASE datepart(month,UC.Expiry_Date) WHEN 12 THEN 1 ELSE 0 END) AS 'December',
SUM(CASE datepart(year,UC.Expiry_Date) WHEN 2014 THEN 1 ELSE 0 END) AS 'TOTAL'
FROM
Upload_Contract UC
where DATEPART(YEAR,UC.Effective_Date)=2014 AND UC.Expiry_Date < CONVERT(date,GETDATE(),103)
