> TRANSFORM
> sum (dp.cantidad) as totalt
> select sum (dp.cantidad) as total, dp.idproducto as codigo
> from pedidos p, detallesdepedido dp
> where p.idpedido=dp.idpedido
> and p.mesenvio = 7
> group by dp.idproducto
> PIVOT
> p.diaenvio
> In CFMX i can make a query like this, if i can how i do
> the ouput
> checo
I would not recommend using TRANSFORM and PIVOT in a cfquery. These
belong to MS Access and are not supported by the SQL standards or by
more scalable databases like SQL Server or Oracle.
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- query Problem sergio mollinedo
- S . Isaac Dealey