Converting Crosstab Query to a Pass-Through Query

[Demian Valle]

I have created a crosstab query in Access that looks like
the following in SQL view:

TRANSFORM Count(table1.seqno) AS CountOfseqno
SELECT table1.event_hour, Count(table1.seqno) AS [Total Of
seqno]
FROM table1
GROUP BY table1.event_hour
PIVOT table1.event_day

I would like to be able to run this as a Pass-Through
query and directly in Query Analyzer in SQL 2000.
However, SQL does not seem to like this syntax. Does
anyone have any ideas on how to change this query so that
it is usable with SQL 2000?

Thanks.

 

[Duane Hookom]

I have created pivots on date fields with case statements that return the
difference between a specific date (possibly a parameter) and Event_Day.
You could wait for the next version of SQL Server or search google on
SQL Server Crosstab

 

[G.C.Mandrake]

For crosstabs directly on sql server check out
the RAC utility.It's similar in concept to Access
crosstab but much more powerful with many
features/options.It also overcomes all those
silly Access restrictions like 1 Transform,
column/row totals,percentages etc.

You will be disappointed with crosstabs in Yukon

www.rac4sql.net