well all done

i have decided to move away from triggers and developed a series of procedures that are totally dynamic. the main sproc is run as a job every 4...

thanks for that

i guess that the main benefit of a sproc is that it does not interupt a write option - ie the insert just happens - and the data...

i realised that the context of the inserted table is within the table and created a temp table that grabs the inserted data. i then insert into the target...

so here is the set-up at the moment

i have no control over the design of the data storage db - it is set in stone

i have another database...

well it is a business decision - we do not own the data - we just store it and render it in html format

i should have been more specific:

the databases are all on the same server. so our sql server has multiple databases - only one of which receives data from remote data...