Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=199020

This seems to me like this is more of a design problem... If the three tables are containing the same information, why are they separated?

I wish I still had that link. But I once read a situation where a report was fetching (not update just select where pk=? which is faster than update)...

You mean scc.com? .

Of course . But the main idea still stands .

I forgot to add the smilies... You're still too much on the defensive. You really have to work on that.

Nice to see you finally learned to use the edit button.

The expression is : "moo point", not "moo". "Moo" alone is a perfect "moo point" .

Typos again >> "moo" point = "moo point"

We're gonna have to have a litte chat.

As long as that crap stays out of the kingdom I don't care which one it is .

To be fair the post ratio is almost 7 to 1, and I actually don't check my spilleng that moch sau yts naurmàle tath Î maque a fiou meaur mistaces...

if exists is an extremely fast operation, especially compared to

1 - create temp table

2,3 - insert into temp (which implies another select)

4 - check to see if the insert...

And see who's always talking about my typos !!

He could just have said "Get a clue" .

Doesn't even need to be clustered (but I'd like to see the speed difference, if any).

Check this for information on covering (compound) index (covering being the best term for this...