How to do an update query

helen_pip · ‎2013-10-03

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

ariel_klien · ‎2013-10-03

Hi,

you can do incremental data

see:

or here

hope this will help you.

Ariel