SELECT CUS_ID, SUM(CASE WHEN type = 11 THEN money ELSE 0 END) AS Salary,
SUM(CASE WHEN type = 12 THEN money ELSE 0 END) AS Loan,
SUM(CASE WHEN type = 13 THEN money ELSE 0 END) AS Social Security,
SUM(CASE WHEN type = 14 THEN money ELSE 0 END) AS Water, type
FROM dbo.v_result
GROUP BY CUS_ID,type
SELECT T1.Col , T2.Col , T3.Col
FROM (SELECT Condtion 1 FROM table .....) AS T1 LEFT JOIN
(SELECT Condtion 2 FROM table .....) AS T2 ON T1.MemberID = T2.MemberID LEFT JOIN
(SELECT Condtion 3 FROM table .....) AS T3 ON T2.MemberID = T3.MemberID
SELECT CUS_ID, SUM(CASE WHEN type = 11 THEN money ELSE 0 END) AS Salary,
SUM(CASE WHEN type = 12 THEN money ELSE 0 END) AS Loan,
SUM(CASE WHEN type = 13 THEN money ELSE 0 END) AS Social Security,
SUM(CASE WHEN type = 14 THEN money ELSE 0 END) AS Water, type
FROM dbo.v_result
GROUP BY CUS_ID,type
Load balance : Server 05
