I may have mis-read this but...

Can you not join the CRM and your snapshot tables selecting only Comp_id and use the where clause to exclude matched records.

Something like...

SELECT Comp_ID

FROM CRM...

Am I missing something or is the question that the query doesn't run because the exec is stated incorrectly? When I run the code, admittedly with my exec stated...

If the databases are the same, and therefore the stored procedures are also the same, depending on the complexity of you application model (i.e. n tier architecture) you could simply...

Frank and jpipes, my post wasn't at all disrespectful or implying that it was a silly question. I agree that 'The only poor question is the one not asked'. I...

Hopefully though, you're not working on a production system. With all due respect, if you're asking a question as simple as this you shouldn't be playing with business critical...

I have a UDF that allows us to select a single value or a range. It does away with the need for executing dynamic strings. It only works for numeric...

This is something I've been trying to do for a while. The best solution I've come up with is an audit table.

I've looked at writing apps that don't...