Athletic Supporter

Patience

omniscient

Yeah, they told me at PASS that every time you shrink a database a puppy gets killed. :crying:

For best performance with a MERGE, its a good idea to have both source and target tables indexed on the columns used to determine a MATCH. Other suggestions...

Here is an illustration of what I think you're talking about. If my assumptions are wrong, please change the code up to illustrate generally what your tables...

To be sure you get a coded and tested solution, it would help if you could post up some sample data and an expected result set. The people...

Nulland

Salt

(making sounds of head exploding)

Sorry if I misunderstood. I would like to add my thanks for your taking time to post the problem with sample data.

Gummy bear

I never knew you were descended from mercenaries.

Yeah. No good can come from that situation unless he confesses to his client that the...

I am going to add one more wrinkle... initials. Bill Smith may actually be J. W. Smith, but the logic you are talking about would eliminate...