Your verbal description is not really telling me what you're trying to do.

Please provide table def, sample data, expected result and what you've tried so far in a ready to...

One option would be to wrap your example inside a cte and use a conditional conversion in an outer query (using CASE statement).

If you'd like to see a coded version...

torpkev (6/29/2010)

---

That worked perfectly, thanks so much..

I was pretty close in what I had but wasn't quite there.. and the link on dynamic cross tab sounds pretty interesting - i'll...

Here's a code snippet that should get you started.

If you have variable Departments you might want to consider using the DynamicCrossTab approach. If you're not familiar with it you...

gideon.kahl (6/28/2010)

---

Thanks for everyone's contributions. I wasn't the one asking the questions, but I learned a lot from the post.

Wayne's solution above is by far the most efficient of...

WayneS (6/28/2010)

---

lmu92 (6/28/2010)

---

Ok, kinda funny I had to go back to this post within just a few hours...

The first person who "forced" me to do it actually created...

Will one of the following queries get you started?

SELECT *

FROM msdb..sysjobactivity

SELECT *

FROM msdb..sysjobhistory

SELECT *

FROM msdb..sysjobs

WayneS (6/28/2010)

---

Lutz, I'm just giving you a chance to show a better approach. 😀

Seriously, I...

Jeff Moden (6/28/2010)

---

Except for the fact that I'm generally against using INT to store ISO dates, there's no need to change it here because it won't help for this particular...

Ok, you've done the first step already (create a query using fake table names).

The next step would be to post the fake table DDL and the insert scripts for the...

Can you post the create index script for the related index?

Using Dans ready to use sample data I'd go with the following solution:

SELECT ServerName,PartNum, PF

FROM

(SELECT PartNum,ServerA,ServerB,ServerC,ServerD

FROM @t) p

UNPIVOT

(PF ...

@Wayne: any specific reason not to use the VARCHAR(8000) version (aka dbo.DelimitedSplit8K) in this case?

And I second bteraberry: The other approaches are known as listed under "not recommended". 😉

Any particular reason for not using COUNT(*)?

But more interestingly: is there any index available supporting the WHERE clause?

If not, can you change it to benefit from an existing index (e.g....

Sounds like homework to me...

If so, you should show us what you've tried so far and where you get stuck.

We might be able to give you a hint towards the...