GilaMonster (10/5/2010)

---

And just when I thought the project I'm on couldn't get any worse..

We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting...

Is there a question? :unsure:

Please provide ready to use sample data as described in the first link in my signature.

Side note: Your required output is not a table anymore... Formatting like you require should...

removed (duplicate /unfinished post)

Please have a look at the CrossTab article referenced in my signature to see an alternative to PIVOT. Once you understand how it works, read the DynamicCrossTab article to be...

Since it's a production server and it seems like you don't know how to do it and -much more important- what to do BEFORE...

Version A:

Step 1: Verify that the current solution will return the requested result.

Step 2: Understand how it works. When...

@Digs:

I'd be interested to see the performance results of Jeffs latest version compared to my approach.

I'd like to see the effect of multiple sort operations (like I do) vs....

Depending on the business case, maybe a full-text search is an option, too...

Other than that I second Chris: you should consider to store the data in separate columns.

As a side...

Based on the information we have so far it's almost impossible to help...

There are many possinle issues causing the bad performance:

[SET GUESSING ON]

1) poor database design (why are there 3-5...

Thanx Jeff for cleaning up the sample data!

And here's my approach:

I'm not sure how it'll perform on a larger data set due to the double sort operation. But it might...

Digs (10/3/2010)

---

My confusion comes, from the fact that I have posted many threads with BULK INSERT of data setups, with no troubles at all.

But i take your point, easier...

Did you...

Please provide ready to use sample data as described in the first link in my signature.

It's unlikely you'll find somebody converting the data for you.

I would use something like SELECT...

Glad I could help 😀