When i executting this query its show records like this..
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)=@Year AND UC.Expiry_Date < CONVERT(date,GETDATE(),103) AND
UC.Company_Unit_id IN(
SELECT CAST(Item AS INTEGER)
FROM dbo.SplitString(@Unit_Id, ','))
or UC.Company_Sub_Unit IN(
SELECT CAST(Item AS INTEGER)
FROM dbo.SplitString(@Sub_Unit_Id, ','))
or UC.Department_Id IN(
SELECT CAST(Item AS INTEGER)
FROM dbo.SplitString(@Department_Id, ','))
Jan Feb Mar April May soon.......
23 34 243 43 543 54
so can i view records like this
jan 23
feb 34
mar 243
april 43
and soon.......
plz give me some suggestion how to do........