How to do an update query

helen_pip — Thu, 03 Oct 2013 10:44:36 GMT

Hello

I have a piece of SQL which loads in data for the last year from Today's date. I schedule this information to run once a week

However, what I really want it to do one load of the SQL where I can date it back to 2010

and then once a week, my schedule SQL will run and update the original load (which dates back to 2010) but just refreshes the last year

Can anyone let me know that initial steps I need to take (I think I know the first 3 stpes)

I.e.

1) Load data back to 2010

2)Store data for 2010 (In a QVD?)

3) schedule SQL to run weekly

4) ??

Any help or advice will be greatly appreciated

Thanks

Helen

Re: How to do an update query

ariel_klien — Thu, 03 Oct 2013 11:41:10 GMT

Hi,

you can do incremental data

see:

or here

hope this will help you.

Ariel