Viewing 7 posts - 16 through 22 (of 22 total)
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...
August 13, 2003 at 1:14 am
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...
August 12, 2003 at 12:15 am
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...
July 30, 2003 at 12:33 am
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...
July 28, 2003 at 3:22 am
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...
July 25, 2003 at 12:16 am
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...
June 18, 2003 at 2:32 am
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...
June 18, 2003 at 2:25 am
Viewing 7 posts - 16 through 22 (of 22 total)