how to insert one table data to another table by sql query in every day automatically in 1 pm

Question

0.00/5 (No votes)

See more:

Hello,

how to insert one table data to another table by sql query in every day automatically in 1 pm.

thanks in advance

Posted 4-Oct-11 19:37pm

K N R

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2011-10-04T19:40:00

Solution 2

Once again you could run a SQL job [^]and insert into tables as and when required.

Posted 4-Oct-11 19:40pm

Abhinav S

Comments

K N R 5-Oct-11 1:43am

Hi abhinav,

thanks for your reply. but i want query with specific time

thanks.

Simon Bang Terkildsen 5-Oct-11 1:49am

Just follow the guide Abhinav S provided you.. you'll see you can schedule the job when you create it..

Abhinav S 5-Oct-11 1:55am

Just use Simon's query in a job and things should work.

Espen Harlinn 5-Oct-11 18:14pm

Excellent as usual :)

Abhinav S 6-Oct-11 7:28am

Thank you.

Simon Bang Terkildsen · Answer 2 · 2011-10-04T19:38:00

Solution 1

SQL

insert into table1 (col1, col2, col3) select col1, col2, col3 from table2

Posted 4-Oct-11 19:38pm

Simon Bang Terkildsen

Updated 4-Oct-11 19:50pm

v2

Comments

Abhinav S 5-Oct-11 1:41am

My 4 this time. You missed out that he needs to run the query at a particular time daily.

Simon Bang Terkildsen 5-Oct-11 1:43am

So I did, thank you for notifying me and providing the info. You got my vote

K N R 5-Oct-11 2:04am

is it possible to write where condition in table1

Simon Bang Terkildsen 5-Oct-11 2:09am

if you mean table2 yes, doesn't make sense for table1, e.g.
insert into table1 (col1, col2, col3) select col1, col2, col3 from table2 where col1 = '12' and col42 is null