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却提示不行!搞不懂!