Post reply

Creating self inserting and self updating records..

  • April 19, 2007 at 11:28 pm

    #173727

    I am new to SQL server 2005. I need to create a table in which rows would add automatically and could be updated automatically everyday.. Can this be done? Can triggers help me with this problem? How do i make these scheduled updates and inserts?

  • April 24, 2007 at 3:38 am

    #702092

    Hi

    I do mine on the dailiy loads of the DW. My updates are coded within procs that check unique fields and insert those if they do not exist in the dimension tables. A simple sample of a query is

    select field from fact_table

    where field not in (select distinct field from dim_table)

    Hope this helps

    Jacques

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply