想請問SQL server 中的SQL怎麼寫！

[longwycn]

個是ACCESS 的，如何寫在SQL Server !



SELECT Rpt_Vendor.fldVendorCodeS, Rpt_Vendor.fldVendorNameS, Sum(1) AS Total, Sum(IIf([fldStatusS]="Pass" Or [fldStatusS]="U.A.R.",1,0)) AS PassFROM Rpt_Vendor
GROUP BY Rpt_Vendor.fldVendorCodeS, Rpt_Vendor.fldVendorNameS;

[zheninchangjiang]

SELECT Rpt_Vendor.fldVendorCodeS, Rpt_Vendor.fldVendorNameS, Sum(1) AS Total, Sum(case when [fldStatusS]="Pass" Or [fldStatusS]="U.A.R." then 1 else 0 end) AS Pass FROM Rpt_Vendor
GROUP BY Rpt_Vendor.fldVendorCodeS, Rpt_Vendor.fldVendorNameS

[RC108]

SELECT Rpt_Vendor.fldVendorCodeS, Rpt_Vendor.fldVendorNameS,
Sum(1) AS Total, Sum(case when ([fldStatusS]='Pass' Or [fldStatusS]='U.A.R.') then 1 else 0 end) AS PassFROM ,Rpt_Vendor
GROUP BY Rpt_Vendor.fldVendorCodeS, Rpt_Vendor.fldVendorNameS

[victorycyz]

SELECT fldVendorCodeS,
fldVendorNameS,
Sum(1) AS Total,
Sum( case when [fldStatusS]='Pass' Or [fldStatusS]='U.A.R.'
then 1
else 0
end
) AS Pass
FROM Rpt_Vendor
GROUP BY fldVendorCodeS, fldVendorNameS;

[zheninchangjiang]

上面的错了
SELECT Rpt_Vendor.fldVendorCodeS, Rpt_Vendor.fldVendorNameS, Sum(1) AS Total, Sum(case when [fldStatusS]='Pass' Or [fldStatusS]='U.A.R.' then 1 else 0 end) AS Pass FROM Rpt_Vendor
GROUP BY Rpt_Vendor.fldVendorCodeS, Rpt_Vendor.fldVendorNameS

[zheninchangjiang]

搞笑了，不要介意

[longwycn]

自己看幫助搞定了　謝謝　，呵呵！

[longwycn]

自己看幫助搞定了！　呵呵！