Sure... but let's just say you're storing the bitmap as 16 bits (using any of a couple of methods)... what do you have to do if you add a 17th...

... and now everyone knows why I asked four times what the heck the EXE was doing!

First, I gotta say, it sounds...

Rather than denormalizing with a bit-wise operator, why not just make a simple normalized table of Holidays with the region code?

...and I guess the words "formatted code" just aren't in your dictionary, huh?

I think you're the same guy from the "other" forum that asked the same question.... if I recall correctly, you will actually receive two 500GB files from your client.  That...

...and, still, we don't know what the EXE is doing...

Nope... it's likely a batch job to be run only one batch at a time... but I do get your point.

Must be a difference in boxes we're running on... I don't come up with your's being 3 times faster, but the point about the WHILE loop method is still well...

Z'actly...

Very cool... and, now you know why I wait a day or two before adding anything to the script library   Nice job,...

Heh... "Worked up" isn't the point... the real fact is, it shouldn't have happened that way and they shouldn't be in the position where they have to shrink it... of...

Yes like bnordberg said this is from a system generated log file.

Then, the bottom line is, you probably...

High praise coming from the likes of you, Peter!  Thank you and I know which "Script Library" you're talking about... I'll throw it in in the next day or two. ...

Thanks for the great feedback, David,

Couldn't believe the pickle someone put you into... had to do something to get you out of that mess

You'll need to grant DDL Admin role privs those users.