General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
He realizado este SELECT en SQL-SERVER 2005 y me funciona perfecto, el problema está cuando quiero llevar dicho SELECT a un formulario de consultas en Visual Foxpro 9.0
Ejemplo:
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
¿Como Lo realizaria en Visual Foxpro 9.0?
Muchas Gracias de Antemano.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only