Advertisement

06.23.2008 at 01:16AM PDT, ID: 23506854
[x]
Attachment Details

SQL - Copy todays records from one table to another table (Scheduled)

Asked by jlsergeant in MS SQL Server, SQL Query Syntax, MS SQL DTS

Tags: MSSQL, 2003

Using MSSQL 2003. I need to copy all records from 'table1' where field value 'todaysdate' = (the current day) to 'table2'. I would like to schedule this to occur every night @ 11pm. How could this be done?Start Free Trial
 
Keywords: SQL - Copy todays records from one …
Title
1 schedule insert process
2 Scheduling events in Access- how to…
3 ASP Scheduler
4 MSSQL server stopping each night
5 MSSQL-Scheduler
6 Scheduled backups not working
 
Loading Advertisement...
 
[+][-]06.23.2008 at 01:49AM PDT, ID: 21844465

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]06.23.2008 at 01:53AM PDT, ID: 21844476

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, SQL Query Syntax, MS SQL DTS
Tags: MSSQL, 2003
Sign Up Now!
Solution Provided By: elimesika
Participating Experts: 2
Solution Grade: B
 
 
[+][-]06.23.2008 at 07:38PM PDT, ID: 21852127

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628