视图支持CASE语句的。
create view v1 as
SELECT EMPLOYEE_UUID,
Sum(CASE WHEN FLAG_CD=1 THEN isnull(AMOUNT,0) ELSE isnull(-AMOUNT,0) END) AS PAYABLE
FROM EMPLOYEE_PAYROLL_ITEM_DETAIL
GROUP BY EMPLOYEE_UUID
create view v1 as
SELECT EMPLOYEE_UUID,
Sum(CASE WHEN FLAG_CD=1 THEN isnull(AMOUNT,0) ELSE isnull(-AMOUNT,0) END) AS PAYABLE
FROM EMPLOYEE_PAYROLL_ITEM_DETAIL
GROUP BY EMPLOYEE_UUID
AS
SELECT EMPLOYEE_UUID, Sum( CASE WHEN FLAG_CD=1 THEN AMOUNT ELSE -AMOUNT END ) AS PAYABLE
FROM EMPLOYEE_PAYROLL_ITEM_DETAIL
GROUP BY EMPLOYEE_UUID
GO
create view 视图名
as
SELECT EMPLOYEE_UUID, Sum( CASE WHEN FLAG_CD=1 THEN AMOUNT ELSE -AMOUNT END ) AS PAYABLE
FROM EMPLOYEE_PAYROLL_ITEM_DETAIL
GROUP BY EMPLOYEE_UUID
as
SELECT EMPLOYEE_UUID, Sum( CASE WHEN FLAG_CD=1 THEN AMOUNT ELSE -AMOUNT END ) AS PAYABLE
FROM EMPLOYEE_PAYROLL_ITEM_DETAIL
GROUP BY EMPLOYEE_UUID