update table in sql 2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

I have two tables namely 'stock(ItemName,Quantity)' and WeeklyStock(ItemName,StartQuantity,date).

I want to update WeeklyStock table from stock table at the end of the week(on sunday 1:00 am automatically) when the server date and time becomes sunday 1:00am.

I mean every item listed in table "stock" should be inserted to the "WeeklyTable" table at the end of week, please advice me as to how this can be achived ?

Posted 4-Apr-12 20:14pm

Member 7909353

Updated 10-Apr-12 20:08pm

v13

Add a Solution

Comments

tulasiram3975 5-Apr-12 2:17am

Better Do it in server side Check Dates And Do Your Work..

member60 5-Apr-12 2:28am

why did you think of trigger first ?

Bala Selvanayagam 9-Apr-12 7:30am

SQL Scheduled Job may be the asnwer for your question.

Having said that you are saysing its not shown. Can you please go into more detail and tell us what version of SQL server you are using ?

Member 7909353 11-Apr-12 0:44am

I am using sql 2005

Bala Selvanayagam 11-Apr-12 2:14am

What specific version in SQL 2005 ? express / standard / enterprise ?

Member 7909353 13-Apr-12 8:38am

Express

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)

Mycroft Holmes · Answer 1 · 2012-04-04T20:40:00

Solution 1

No use a SQL Job - assuming you are using SQL Server. The Job should execute a stored procedure that updates your weekly data table.

Posted 4-Apr-12 20:40pm

Mycroft Holmes

Comments

SDAP_INDIA 5-Apr-12 6:14am

yessssss

Member 7909353 9-Apr-12 2:52am

How to set stored procedure to my table(WeeklyTable).

Mycroft Holmes 9-Apr-12 3:49am

First create and test your stored procedure. Then in the job definition you can enter the name of the stroed procedure

**AmitGajjar** · Answer 2 · 2012-04-05T02:13:00

Solution 2

Hi,

Follow Schedule a job link, it may help you,

thanks
-Amit.

Posted 5-Apr-12 2:13am

AmitGajjar

Comments

Member 7909353 9-Apr-12 2:53am

SQL Server Agent does not shown.

AmitGajjar 9-Apr-12 2:56am

What version of SQL server you are using ?

Member 7909353 11-Apr-12 1:33am

I am using sql 2005.

AmitGajjar 11-Apr-12 2:02am

i mean Express edition / Enterprise edition ? or what else ?

Member 7909353 13-Apr-12 8:39am

sql 2005 express.