Adding to historic table

Followers

November 28, 200817 yr

Hi all,

Not sure quite how to go about this one, I'm sure it is quite straight forward to someone here!

I have 2 tables:

DataToday

DataHistoric

At the end of the business day, someone will run a script which takes the data from DataToday (100 records) and adds these 100 records into the dataHistoric table.

It is only about 100 records, maybe a few more, maybe a few less but not exactly 100.

Would a script be the best way to go about this?

Many thanks

Edit: Should have mentioned that a script runs the following morning deleting all records in DataToday to clear it ready for that day

Thanks

Edited November 28, 200817 yr by Guest

November 28, 200817 yr

Author

Sorry I would like to change this slightly.

What I would actually need is for each night a script to run that looked in the DataHistoric table and exports all the records taht have a date of today into the DataToday table

I dont want to have to do an export then a seperate script to do an import which is the only way I know how I could do that.

Many thanks again