Ivan,

Your post is almost incomprehensible to me. Could you edit out the abbreviations and put real words in their place so I can understand what you're trying to say?

Really? I haven't seen one that doesn't use traces or triggers. Please, tell us what those tools are. I'd like to test...

Maina-456685, Could you provide sample data so Chris and I can verify solutions before we post them?

I'm fairly certain you don't need the GROUP BY and HAVING on the Contract insert. Test it to verify, but everything after the c.CellphoneNo IS NULL should be able to...

Look up Convert, the Transact-SQL reference, in Books Online. Halfway down...

Indian Giver.

Wow, Grant. What a way to make the Threadophiles feel unwanted...

@=)

WayneS (10/26/2010)

---

Is there a way to have a query that generates dynamic columns exported to an excel spreadsheet? The problem that I've run into is that in the Data Flow,...

I prefer Convert() over Cast() because I can do string tricks with my GETDATE() and still take it back to a valid datetime value. I'm not sure if you can...

I just noticed another problem. At no time in this scenario, Maina-456685, are you actually checking dbo.Contract for duplicates. You only ever check your staging table, dbo.TempCustomer for duplicates.

So what...

Ah. I did not catch that fact. Chris, you are correct. So even if the ContractAuditID problem is corrected, the code will still fail.

A few minor nitpicks that might not matter in your current environment but could cause problems for you later. (FYI: Grain of salt moment. These just happen to be two...

Maina-456685 (10/27/2010)

---

Condition 1: If an entry is duplicated in TempCustomer, insert into ContactAudit table.

....

Condition 3: If an entry is not duplicated in TempCustomer, but already exists in Contact,...

Dread,

Glad your problem is resolved and thank you for posting your solution.

If you ever do remember the forum name or the forum thread, please make sure to link it...

Yeah, my edit must have crossed your posting.