Yes - I think what makes my situation different is that I need to track the source/audit info on a per column basis. Each column has a sort of waterfall...

Yes - agreed about the EAV design. I'm trying to avoid it at all costs - it's temping because on paper it gives me the functionality I need. But I'm...

ChrisM - that MERGE is brilliant. I will try out all these solutions and probably go with whatever is fastest. MERGE statement seems very powerful and flexible as it let's...

Thanks for the quick reply. So basically this is a two-step update, first an update then inserting the duplicates. I will experiment with that and see if it works for...

Hi - I have a similar issue to the one discussed here. Wasn't sure if I should create a new thread or not, first I'll try reviving this one.

I also...

The issue is that these systems are not all in the same database or server. The systems communicate with each other via messaging. e.g. The trade entry system sends out...