Thanks very much...

i knew the original post was gnarly but thought i could get away with it, but it was too ugly.

My first boss, Lior Hod, also refused to read...

Thanks very much for your help and advice, i appreciate it.

drew

forgive me, i apologize.

the attachment is cleaned up and will run in tempdb

i still have to generate some tables and sample data.

thank you for your time

drew

there's a lot of funk in the sprocs, so i uploaded them too.

im sure the examples' submission could be improved, but i hope they are adequate to illustrate the issue.

thanks...

Thanks very much, i will take a look at the resource you mention.

Performance is not acceptable.

I appreciate your help and will be back.

drew

thanks very much

i was trying to avoid the overhead i thought i saw in the execution plan, but something you said piqued my curiosity:

could it be possible to coerce...

Good God i had no idea reading could make me feel so smart!...now it just has to sink in

Thank you very much for explaining the intracacies of each path.

drew

thanks very much Mr. Moden, I really appreciate your help

drew

Something along these lines seems promising, but i can't get out of my own way....

select * from

(

select SUBSTRING(c1,1,1)[1], SUBSTRING(c1, 2,1)[2], SUBSTRING(c1, 3,1)[3],

SUBSTRING(c1, 4,1)[4],SUBSTRING(c1, 5,1)[5]

from t1

)x

unpivot (c1 for x in...

Thanks very much.

I was laboring under the misapprehension that SBS precluded what version of SQL Server could be used. I will follow your advice and use backup and restore to...

Thanks a ton, will do.

My issue with the cast is that, believe it or not, net is delivered as a varchar, and so i cannot sum it, so that's...

its barely enough to move the needle...heres the gory details...

i do a datediff in ms from start to finish

declare @start datetime

declare @end datetime

then set up #t1 from institutional header...

like Carl Sagan used to say...

it needed a select distinct on the final query, but it worked.

I can't thank you and Old Hand enough for opening my eyes.

best

drew

thanks so much...

its doing what i need.

drew

looking forward to it!

I want you to know i am standing up at my desk to say Thank You immensely for your time and effort Mr. Moden!

drew

ps. this sucka runs...