Pivot Table Help

[fmrock]

Hey Everyone,

I am trying to come up with a query for a report for one of our managers.

We have a system that that our department uses to keep track to workorders/tasks.

Basicly the report we are wanting is wanting to show how may orders where opened/closed per person, per week.

The data is stored in a table called "tasks"... and there are 2 date colummns, Date_Entered and Date_Completed.

The manager manually counts all of these up and add them to a spread sheet that looks something like.


User, Week1 Opened, Week1 Closed, Week2 Opened, Week2 Closed and so on....

Any one have any ideas on how i could acomplish this in one query? Which i am guissin has to be a pivot query.

 

[ESquared]

Honestly, I think the best thing if you are going to use Excel is to push the summarized but unpivoted data to excel and then create an Excel pivot table.

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]

 

[nomadicalloy]

Please look at this example

http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables

thanks


This is Signature

http://www.xpherion.com/

 

[ESquared]

Auto Pivot in SQL 2005

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]