Can you change the select statement so that if there is only one level in the path (ie. nothing after \Beverages), nothing is returned?

For example:

if instead of \Beverages\Soda Pop\Mountain...

Thanks CC. My learning curve is steeper when I get help. It may look lazy but in fact I am not.

Thank you!!!!!

WELL, I'm working on it myself, and certainly not expecting you to do it for me, but if you do you can be sure I'm still learning.

Thanks.

nope, it's different. That one wants the first segment of the path ie. Beverages. This one wants what comes after.

http://www.sqlservercentral.com/Forums/Topic1281987-392-1.aspx

Do you mind describing in words what the desired outcome represents? Whats the story?

Jeff, can I use cross tabs (or pivot) to aggregate by both Year and Quarter horizontally and by application vertically?

I would say that it would create such a wide report,...

good point. thanks again.

Yes, I will learn Cross Tabs next. It's on my to do. I've got to get Pivot down and then I am psychologically read to take on Cross Tabs....

Lyn, I noted you aggregated within the from clause, necessitating columns be explicitly defined.

COUNT(*) over (partition by application) as total

thank you.

There was only one problem. I was trying to use YEAR function within the PIVOT operator. I can get the same results with count(workitem_id) as in:

select

application

, [2010]

, [2011]

,...

Fitz, please show me. I have no idea what you are talking about.

Thanks. I was missing a right parenthesis and alias for the inner. 😛 I was modeling it this way because in real life the WorkItems table has many more columns....

actually, I thought he was taking the first date of one status (top Active) and the first date of the second status (because of reverse ordering) when I first read...

Dwains does pretty much exactly what needs to be done even with the additional business rules, with the exception that it errors in two places:

WA_Traffic Proposed should be 30-60 days,...

Drew,

please explain how 'Days' is introduced. Since you and Dwain are both using DATEDIFF to extract

day portion of the datetime, I would have expected your CASE statements to...