how to transfer data from one table to another ?

Ideally, I would go for the above solution but in some instances you would want a redundant data set. In this scenario,

What is the difference between dates within different products in tbl_future ?
For example, consider the below data rows in tbl_future:

1000 Product1 2011-01-01 12:00:00.000
1001 Product2 2011-01-01 12:00:00.000
1002 Product3 2011-01-01 13:00:00.000
1003 Product4 2011-01-01 13:00:00.000

I am asking this because the below solution will have to be scheduled on the correct analysis of the above data

Say for example, the batch of products have datetime differences by 0.5 hours

Then schedule a job which runs every 0.5 hours or every 5 minutes depending on the volume of the data with the following sql statement

insert into tbl_live
    select id, product from tbl_future where upTime = getdate()
-- here upTime is the datetime column in tbl_future