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:2365
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
