timothyawiseman (3/3/2008)

I am trying to check...

And, because of the way it sounds like you're doing things, it could also be when Auto-grow runs... especially on your TempDB. Preset TempDB big enough so it NEVER...

Fluctuations in connectivity or other network issue? Have you got proof that's what it is? My bet is on some code that runs in the background somewhere...

Wouldn't it be easier to change the color of a cell using "conditional formatting"?

I absolutely agree that this type of formatting should probably be done in the GUI...

... but it's too damned much fun doing it in T-SQL :D:P;):w00t::hehe::)

Ian... I got carried away......

It seems to me that a bit of divide and conquer will make this run much faster... when you're all done, look for PatientID's that have a Parm of 5....

Ya know... you'd get a lot better help quicker if you did what the URL in my signature lines tells you to do... just a thought... 😉

zactly....

Ya do gotta be flexible... shoot... I even taught myself how to run plenum cable and make both Cat 3 and Cat 5 teminations... had to do it because I...

Me too 😉 ... I know zippity-squat on the SSIS and the SSRS sides of the house... zippity-squat times 2 on the development studio. Like what's been already stated,...

Thanks for the feedback, Tom... the standards are kinda long... most of them are really based on common sense and things that have actually gone wrong at my current company....

I'm curious... why would you use UNION ALL or OR on such a thing?

brkn eng dif 2 ustd abv b wrs plz stp ko? 😉

Nicely done, Mike. By the way, in SS 2k QA, press the {f4} key and see what comes up. 🙂

Thanks. I'll give this a whirl after work, today.