close
[免稅扣項名稱]=
(Case when SalaryResult.LabourEmpFee != 0 then 'Phí bảo hiểm lao động,' else '' end)+
(Case when SalaryResult.HealthFee !=0 then 'Bảo hiểm sức khỏe,' else '' end) +
(case when SalaryResult.EmpTax != 0 then 'Thuế thu nhập,' else '' end)+
(case when cast(convert(varchar(50),SalaryResult.Emp2ndNHI) as decimal(18,8))!= 0
and SalaryResult.Emp2ndNHI Is not null then 'Premium supplement,' else '' end)+
(case when WithoutTaxCatItems.ItemName is not null then (WithoutTaxCatItems.ItemName + ',') else '' end),
文章標籤
全站熱搜