>select fecha_des,case when horario=1 THEN 'AM' ELSE 'PM' END AS HORARIO, SUM(case when cod_lin='L01' THEN min_prod ELSE 0.00 END) AS MP1, SUM(case when cod_lin='L01' THEN min_espe ELSE 0.00 END) AS ME1, SUM(case when cod_lin='L01' THEN min_ocio ELSE 0.00 END) AS Mo1, >SUM(case when cod_lin='L02' THEN min_prod ELSE 0.00 END) AS MP2, SUM(case when cod_lin='L02' THEN min_espe ELSE 0.00 END) AS ME2, SUM(case when cod_lin='L02' THEN min_ocio ELSE 0.00 END) AS Mo2, >SUM(case when cod_lin='L03' THEN min_prod ELSE 0.00 END) AS MP3, SUM(case when cod_lin='L03' THEN min_espe ELSE 0.00 END) AS ME3, SUM(case when cod_lin='L03' THEN min_ocio ELSE 0.00 END) AS Mo3 from encnotdes GROUP BY fecha_des,horario ORDER BY fecha_des,horario >>
select fecha_des,ICASE( horario=1, 'AM', 'PM') AS HORARIO,SUM(IIF(cod_lin='L01',min_prod, 0.00)) AS MP1, SUM(IIF(cod_lin='L01',min_espe,0.00)) AS ME1, etc. for other sums from encnotdes GROUP BY fecha_des,horario ORDER BY fecha_des,2CASE function in SQL Server translates into IIF or ICASE function in VFP.