I think the most important thing, is actually doing it.

One of the biggest problems i've seen people face learning SQL is that they'll have the technical aspects nailed down pretty...

that's exactly what i was thinking. In many case there's no way...

I actually do something very very similar in an app i work on. We have a rates table that has rates for given services. These rates may change fairly often,...

ej - two things.

First, it doesn't appear you're raising an error anywhere, which, I believe is part of why it's not doing anything. Even if it does catch a MerchantID...

If the two temp tables have the exact same data as you say - this seems like a waste of time?

You're essentially comparing a table to it's self and performing...

First, how do you know that you're losing these inserts?

Second, are you positive that the data you're attempting to insert is valid?

I would go with the previous advice...