How do I copy data from 10 columns in Table A, Database A to Table B, Database B on the same server.
I need to mark the data I copied, then repeat the process every 30 mins.
I plan on using the SQL Agent for creating a job to run the SQL for the process.
Any Advice ?
Thanks,
Mohit.