Did you or anyone else find a solution to this problem?
>I have a crosstab query that I created in Access and it pulls my numbers
>just fine. Now I want to write a query for a CF page to get the same
>results. I am using SQL server, but it does not accept 'PIVOT.' Does
>anyone know how I can get around this. Here is a pared down version of
>my crosstab query. I want to find a count of problems that occurred by
>location (row heading)and by month (column heading).
>Zelda
>
>
>TRANSFORM Count(SEQ_NR) AS CountOfSEQ_NR
>SELECT LOCATION, Count(SEQ_NR) AS Total
>FROM PROB_TBL
>WHERE DTE_OCC) Between #1/1/2006# And #12/31/2006#
>GROUP BY LOCATION
>PIVOT Format([DTE_OCC],"mmm") In
>("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"
>);
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2408
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
