Yeah... you're right on both counts... not enough coffee here... 😉

Heh... wha? Moi? Oh... you mean I started it all with my "statement prefix"? 😛

BWA-HAA! See why I hate the damned things? You guys are still going on about punctuation marks... :P:hehe:

Bob Hovious (12/30/2008)

---

Peculiar... on our 2008 development box (which is pretty quiet this week), I ran Jeff's original test and all three ran almost neck and neck. ...

Heh... Z'actly...

Thanks, Perry.

Heh... I thought binaries were illegal in the U.S. I thought uni-level was the only legal method for an MLM.

Change the commented code in the script I posted and you'll be 2k compatible in the blink of an eye. 😉

Does that mean you were able to drop it by matching case?

Perhaps it's time to post what the tables look like and what the data looks like. Please see the link in my sigature below for how to get the...

Thanks... guess the rowcounts you gave will do just fine. Don't worry too much about the data... I guess I can gin something up.

Heh... yeah, I keep forgetting stuff like that in my old age. Look what...

josemyj (12/30/2008)

---

Is a good aproach, but keeps a very big SQL when we reach the 2000 fields.

The problem: Users have a list of their shops, and choose between 4000 arbitrarily....

Double post. Please don't post here. Follow the link below to the other post.

http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspx

You have 2 activity columns... what are they really called?

And please... not nice to double post.