Move Select statement from MS Access to SQL Server

[Mansi]

Hi,


I have select statement below written in MS Access, I want to use it in sql server side, How Can I move it to be run there?


SELECT [History Other Charges].Institution, Sum(IIf([other_item]='ID' Or [other_item]='CID',[other_extended],0)) AS Internal, Sum(IIf([other_item]='DRCTS',[Other_Extended],0)) AS Dr_Coats, Sum(IIf([other_item]='ML',[other_extended],0)) AS Misc_Linen, Sum(IIf([other_Item]='Mops',[other_extended],0)) AS Mops, Sum(IIf([other_item]='PR',[other_extended],0)) AS Plastic, Sum(IIf([other_item]='Rags',[other_extended],0)) AS Rags, Sum(IIf([other_item]='SPCHG',[other_extended],0)) AS Special, Sum(IIf([other_item]='ABS',[other_extended],0)) AS ABS, Sum(IIf([other_item]='GCC',[other_extended],0)) AS GCC
FROM [History Other Charges]
WHERE ((([History Other Charges].Other_Date) Between #3/1/2010# And #3/31/2010#))
GROUP BY [History Other Charges].Institution;

thanks in advance,
MM

[pbaldy]

Sure; IIf() does not exist in T-SQL, but you can use CASE instead. Check out the syntax in BOL. Also, in T-SQL you'll want to surround the dates with single quotes instead of #.