We have 2 main tables on two different servers
Table A is the primary Table on primary Server
Table B is a replication of the primary Table on Secondary Server
Table C [1 day of Table B's Data] (On same server and database-secondary server)
I want to know how/what is the best method
for creating a third table which contains only 1 day worth of Data
I will write a script which deletes all data from table C for old data
that runs every night.