Adding to historic table

[eddyb2]

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

Ed

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, 2008 by Guest

[eddyb2]

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

Ed