SELECT TOP 100 PERCENT SoghDate, CONVERT(varchar(6), soghdate, 112)
AS SoghMonth, SUM(ckcps) AS ckcps, SUM(kkcps) AS kkcps, SUM(ckcps + kkcps)
AS sumcps
FROM (SELECT soghdate, SoghFrom,
ckcps = (CASE WHEN soghfrom = '010101' THEN soghTrains ELSE 0 END),
kkcps = (CASE WHEN soghfrom = '010201' THEN soghTrains ELSE 0 END)
FROM dbo.gdSogh) tmp
GROUP BY SoghDate
ORDER BY soghDate
AS SoghMonth, SUM(ckcps) AS ckcps, SUM(kkcps) AS kkcps, SUM(ckcps + kkcps)
AS sumcps
FROM (SELECT soghdate, SoghFrom,
ckcps = (CASE WHEN soghfrom = '010101' THEN soghTrains ELSE 0 END),
kkcps = (CASE WHEN soghfrom = '010201' THEN soghTrains ELSE 0 END)
FROM dbo.gdSogh) tmp
GROUP BY SoghDate
ORDER BY soghDate