Clausula Transform?

[[fjcg02]]

Código SQL [-]
SELECT Producto,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='01' then Cantidad else 0 end) as Enero,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='02' then cantidad else 0 end) as Febrero,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='03' then cantidad else 0 end) as Abril,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='04' then Cantidad else 0 end) as MAyo,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='05' then CAntidad else 0 end) as Junio,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='12' then Cantidad else 0 end) as Diciembre

FROM pedidos
WHERE (fecha >= '01.01.2007' and fecha <='31.12.2007') and dia <> '01.05.2007'
GROUP by Producto, substring(cast( dia as char(10)) from 9 for 10)

Prueba a ver con esto ... Ya nos diras

Saludos