You can replace IIF with CASE T-SQL function

iif(month(receiveddate)=7,amount,000000000000.00)
(CASE WHEN month(receiveddate)=7 THEN AMOUNT ELSE CAST(0 AS numeric(12,2) END)

Also check PIVOT type of queries


>Hello all, I am porting a VFP app to NET and SQLServer. I have a fairly complex SQL SELECT that I need to rewrite to be compatible with SQLServer 2008. It includes some lines like this:
>

>select ;
>	sum(iif(month(receiveddate)=7,amount,000000000000.00)) as jul, ;
>	sum(iif(month(receiveddate)=8,amount,000000000000.00)) as aug, ;
>	sum(iif(month(receiveddate)=9,amount,000000000000.00)) as sep, ;
>

>So far I have not been able to figure out how to work the IIF statements into the new code. Can someone give me some ideas here?
>Thanks
>