弄了个视图，但是结果不太满意，现在查询结果是一个人有好多记录不能按人员对收入进行汇总求和，现在想增加个判断将判断结果加上收入存入新的一列，判断 税后收入是否大于800小于4000，是 税后收入=（税后收入-800）* 20% ，大于4000小于20000的 ，税后收入 = 税后收入（1-20%） 20% ，大于20000小于50000的，税后收入= 税后收入 （1-20%） 30%-2000，大于50000的，税后收入= 税后收入 （1-20%） 40%-7000
SELECT dbo.WX_ExpenseClaimPayInfo_View.cVouCode AS 单据号,
dbo.WX_ExpenseClaimPayInfo_View.cUserCode AS 人员编码,
dbo.WX_ExpenseClaimPayInfo_View.cUserName AS 人员名称,
dbo.WX_ExpenseClaimPayInfo_View.cBankAccountCode AS 银行卡号,
dbo.WX_ExpenseClaimPayInfo_View.fPayMoney AS 税后收入,
dbo.WX_ExpenseClaimPayInfo_View.cApplyReason AS 事由,
dbo.WX_ExpenseClaimPayInfo_View.dApplyDate AS 单据日期, dbo.WX_User.cDepCode AS 部门编码,
dbo.WX_User.cCardID AS 身份证号, dbo.WX_PZ.dPZDate AS 凭证日期,
dbo.WX_ExpenseClaimChild.cSubjectCode AS 预算科目, dbo.WX_ExpenseClaimPayInfo_View.cDefine4 AS 税额
FROM dbo.WX_VoucherPZ INNER JOIN
dbo.WX_PZ ON dbo.WX_VoucherPZ.uPZPK = dbo.WX_PZ.uPZPK INNER JOIN
dbo.WX_ExpenseClaimPayInfo_View INNER JOIN
dbo.WX_User ON dbo.WX_ExpenseClaimPayInfo_View.cUserCode = dbo.WX_User.cUserCode ON
dbo.WX_VoucherPZ.cVouCode = dbo.WX_ExpenseClaimPayInfo_View.cVouCode INNER JOIN
dbo.WX_ExpenseClaimChild ON dbo.WX_VoucherPZ.cVouCode = dbo.WX_ExpenseClaimChild.cVouCode
GROUP BY dbo.WX_ExpenseClaimPayInfo_View.cVouCode, dbo.WX_ExpenseClaimPayInfo_View.cUserCode,
dbo.WX_ExpenseClaimPayInfo_View.cUserName, dbo.WX_ExpenseClaimPayInfo_View.cBankAccountCode,
dbo.WX_ExpenseClaimPayInfo_View.fPayMoney, dbo.WX_ExpenseClaimPayInfo_View.cApplyReason,
dbo.WX_ExpenseClaimPayInfo_View.dApplyDate, dbo.WX_User.cDepCode, dbo.WX_User.cCardID,
dbo.WX_PZ.dPZDate, dbo.WX_ExpenseClaimChild.cSubjectCode, dbo.WX_ExpenseClaimPayInfo_View.cDefine4
HAVING (dbo.WX_ExpenseClaimPayInfo_View.cUserCode IS NOT NULL) AND (dbo.WX_User.cDepCode IN ('098', '099',
'999')) AND (dbo.WX_ExpenseClaimChild.cSubjectCode IN ('30010110', '100119', '30010109', '40010607'))
我想要达到的结果某个月，某个人和他的身份证号，在这一期间内的税后收入+判断反算得来的税额。