SQL 视图用IIF = 居然不可以，CASE WHEN居然可以

SELECT MstGENLDept.DEP_DESC, MstFMISWWaste.WDesc,TxnFmisWasteDaily.Weight, TxnFmisWasteDaily.TxnDate, 
(case TxnFmisWasteDaily.Split when 1 then 'Inactive' when 0 then 'Active' end) as Actived, TxnFmisWasteDaily.ActiveDate,'' as Remark, TxnFmisWasteDaily.ID,
(case TxnFmisWasteDaily.ProductionFlag when 1 then 'Production' when 0 then 'General' end) as ProductionFlag 
FROM TxnFmisWasteDaily INNER JOIN MstFMISWWaste ON TxnFmisWasteDaily.WasteCode =  MstFMISWWaste.WCode INNER JOIN 
MstGENLDept ON TxnFmisWasteDaily.DepartmentID = dbo.MstGENLDept.DEP_CODE where ConfirmDate is not null

SELECT MstGENLDept.DEP_DESC, MstFMISWWaste.WDesc,TxnFmisWasteDaily.Weight, TxnFmisWasteDaily.TxnDate, 
(iif(TxnFmisWasteDaily.Split = 1,  'Inactive','Active')) as Actived, TxnFmisWasteDaily.ActiveDate,'' as Remark, TxnFmisWasteDaily.ID,
(iif(TxnFmisWasteDaily.ProductionFlag = 1 ,'Production' ,'General')) as ProductionFlag 
FROM TxnFmisWasteDaily INNER JOIN MstFMISWWaste ON TxnFmisWasteDaily.WasteCode =  MstFMISWWaste.WCode INNER JOIN 
MstGENLDept ON TxnFmisWasteDaily.DepartmentID = dbo.MstGENLDept.DEP_CODE where ConfirmDate is not null

两个语句执行窗口下都可以通过，但是放到视图里面后IIF却提示不行！搞不懂！