Incrementally inserting data into a table from other tables.

• Hakuna Matata

  SSCertifiable

  Points: 5577

  More actions

  May 25, 2011 at 5:03 am

  #251647

  Hi,

  I have created a table whose data is populated based on other tables in the database. This table is meant for reporting purpose & i need to create a job that will populate the table once a day. This job has to add the new data to the existing data in the table.

  For example suppose i have populated the table & the table has 100 records as of now, when the job runs & if the query is retrieving 50 records. the 50 records have to be added to the 100 records, making the count 150.

  I have created an extra field in the table set to IDENTITY so that the table has a column with unique values.

  How can I go about this?

  Regards,

  Nithin

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 25, 2011 at 5:34 am

  #1329599

  Insert into rpttable ()

  Select from prod where not exists (check in rpttable)