What is that requirement?  Why does this need to be done?

...was thinking of large tables, which would make sense to turn off auto update statistics...

WHY?

Oooo, ... you've implimented this as correlated subqueries in the SELECT list... not what I had in mind at all... I gotta think about this a bit but I was...

Heh... yeah, I've been burned by the throw-away timeout on this forum many a time at first... I've learned to always [Ctrl-a][Ctrl-c] before I even think of hitting [Post Reply]......

Um, you need to go back and read the code, Ken...  I'm not really relying on "Physical" implimentation at all and you should never try this on a "column without an...

> have a table with just the mile_codes in it and tried tying that in but can't seem to get it to work.

Do an outer join to that table...

Kenneth, you...

>"WOW!"  This is pretty cool. Not only does it work great, but is giving me some more...

Heh... yeah... the site has a "timeout" for some reason... you should always copy the entire body of your post before you hit [Post Reply] so you don't loose anything.

The...

LMtz,

Any of this helping of do you need another "track"?

David,

You list a certain column (Seg or ID, ususally) in each of your tables as a Primary or Primary Key... are they actually Primary Keys with a PK constraint in place? ...

Thanks for the feedback, David... you've restored my faith... sorry for the misread.

You know the drill, Sree... "Show me the data".

The auto update statistics is off.

Luk... Sorry I missed that comment... Like I said... that's a form of...

Not a bad approach but have you tried it on, say, a million rows?  Makes a real busy server if you have 2000 connections trying to do the same thing...