First of all, please stop posting graphics for the test data.  See the article at the first link in my signature line below for why and one method for...

Your other post is on an SQL Server 2022 forum.

Just to be sure, I would never obfuscate numeric data.  If it's worth protecting, it's worth being properly encrypted.

Hi SSC team,

I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables...

I use IIF a whole lot to replace the longer CASE expression in CROSSTABs.  It just makes for shorter code when there are only Yes/No conditions.

I have used some of...

First of all, please stop posting graphics for the test data.  See the article at the first link in my signature line below for why and one method for producing...

Just to be sure... you're in an SQL Server 7/2000 forum... which release of SQL Server are you actually using?

And, yeah... It's really important because there's a whole lot missing...

Hi SSC team,

I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables instead of...

thx jeff.   eventually i did do the divide and conquer thing.  it took the query down from 6 minutes to 19 seconds.   i turned it over in that state...

Shifting gears to the dark side, it may be that the query was written in such a fashion that the optimizer just can't figure out if an index would help...

Ok... so you don't need the xp_CmdShell example then.

Thanks for response, would you be able to mock up an example of how that can be achieve? I just need an easy way to crank out files based...

Not so good... I somehow missed what the OP had in the first post, which is...

Dell PE T430

2 - Xeon E5-2630 2.4GHz

64GB RAM

PERC H730 Controller 1GB cache

2...

Heh... I just get lucky that wway.

There were some fond memories made back then.