I was referring to the suffixe table. As for my convention I take for granted that I select data from tables. If not, then it's from vwsomething or...

Do you think we're gonna get an answer from her??

Thanx for the correction .

2550 to 365 so that would be about 7 times faster than you .

Hehe, I'm not catching up with him... still 3k posts behind. That's hardly close enough to even talk about it. However I can officially say that my lifetime...

Can't either...

Unless he has Cust1Orders, Cust2Orders...

Have you tried the equivalent set based statement to see which on is the fasted?

That's a neat trick... just have to rethink the way I format my statements now .

Or do you need to have dynamic numbers for that query?

Didn't you just say to me yesterday that you didn't like bol sometimes???

(adrianne - just search there, it's really the best place to start)

I never said it was perfect .

BTW, how would you rephrase that??

Not at all, maybe we'll need yours someday .

Books online. Excellent source of information.

Yup... it seems to be a case where not much will be loss... Make sure you rethink the indexing strategy and recreate any default or check constraint as they will...

Day's over here... I'll try to check that first thing tomorrow morning.