Access Query

[aftabn10]

I was wondering how i can convert the following query created in access to work in SQL.

TRANSFORM Count(daily_effectiveness.JOBTIME) AS CountOfJOBTIME
SELECT daily_effectiveness.EIN, Count(daily_effectiveness.JOBTIME) AS [Total Agent Work], Sum(daily_effectiveness.JOBTIME) AS [Total Time]
FROM daily_effectiveness
GROUP BY daily_effectiveness.EIN
PIVOT daily_effectiveness.ORBITQUEUE;

Thanks in advance.

 

[DCrake]

SQL Server does not support crosstab queries, sorry....

 

[aftabn10]

Hi,

Thanks for your reply. Is their any other way this query could be written in SQL?

 

[namliam]

You have to make (all) the possible columns yourself using "case when" to shift the values to the right columns, then do a group by to count the columns

I hope you understand what I mean....