Thank you for the article, Luis. I will be adding that to my bookmarks.

That works! Thanks!

Jeff,

Thanks for the tips. Two things. Right now, our data set is small enough that the performance hit will be negligible; however it is expected to increase, so I will...

Here it is by OrderDate. Thank you for the solution. That works very well. I can't use the SSRS solution because this data has to go into a Data Warehouse

SELECT...

I appreciate all of your responses. I have learned a whole lot and have been able to incorporate the code into production using your examples.

That would work, but the data goes through an external app and can not use SSRS.

Sorry, I posted too early a while ago without giving you all the tools.

Here is some sample data:

IF OBJECT_ID('TestGroup', 'U') IS NOT NULL DROP TABLE TestGroup

CREATE TABLE TestGroup (PartNumber...

Thanks, but it is listing all of my blank part numbers at the top. What am I doing wrong?

Sometimes I make things more difficult than they should be. Thank you for the tip.

Thanks to everyone for their help. Ed, I am using your solution, and it works perfectly! Thanks.

Thank you, Jeff. That is how I will handle this. Thanks for the solution, and thanks for the reminders.

Jeff,

I guess I was confused about NVARCHAR(MAX). I thought the max was 4000 characters, because when I print the results of my dynamic query it will cut it off. I...

There are two limitations that I see. First, the queries are fairly large, so I bump up against the max. I know I can split it up, but it's...

DBCC ran with no errors.

Keith,

I will do that. However, you are correct. We upgraded this database from 2000 to 2008 R2.