I need to take VFP code and create a SP to do likewise. It's a cross tab so this is what I have currently:
SUM(IIF(ds_progedd.dbo.Demos.strata=2
and type ='IMMU',1,0)) AS standard_immu ,
How do you Case on 2 columns
SUM(caseds_progedd.dbo.Demos.strata when 2
and type when 'IMMU' then 1 else 0) AS standard_immu ,
TIA
__Stephen