It's monday morning and i just got into work. I have to get all of my
weekly reports ran and out. I'm going to try some of the suggestions
after that and will report afterwards.
Unfortunately, Linking the servers is not an option. The third party
software will not let me put triggers, stored procedures or any
alteration to their DB. I wouldn't even be pulling their data into a
DS unless i had to have it. I'm going to give ARUN KUMAR's suggestion
a shot. Looks exactly like what i'm looking for. It looks straight
forward. The DATATABLE.MERGE method looks like it has promise also.
If Kumar's method doens't come to fruition, i'm going to do some
research on that and try to adapt a solution with it.
Thanks greatly for all the suggestions.
Ben
