• monilps (3/5/2013)


    CREATE TABLE [dbo].[pp]...

    CREATE TABLE [dbo].[pp_staging]...

    ALTER TRIGGER [dbo].[patient_property_arrival] ON [dbo].[patient_property]...

    let me know if you need any additinal info. thanks.

    so we have 3 tables involved here, what is the source and destination tables of the data being transfered? Are the tables in the same database? Are you transferring the data in one big gulp or is it broken out into smaller batches of say 1000 to 5000 records?