How can I make a append command to one table?
Ex. If data in one table is 7 days old it would append all 7 days old data into another table.

insert into newtable
select all from oldtable
where Fieldate <= dateadd(d,-7,getdate())

Fieldate is the field that holds your dates


http://sqlservercode.blogspot.com/

How can I do this so it would run on server constantly, and not then when someone loads the page.

if you did it constantly it would duplicate the data constantly, it needs to be done when someone loads a page.