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
