how to increment amount(column name) automatically every day in sqlserver

Question

2.60/5 (2 votes)

See more:

SQL-Server-2012

hi frnds ,
i am new to the sql server ,  please give me some suggestion
in sqlserver i have a two  coulmns like (amount and date ) every day amount should increment by  50 rupees . .please help  me guys , i am not getting how to do . . please 
thanks . .

Posted 11-Aug-14 20:02pm

u mani

Add a Solution

1 solution

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)

Maciej Los · Answer 1 · 2014-08-11T20:14:00

Solution 1

Try:

SQL

UPDATE t1.Amount = t2.Amount + 50
FROM TableName as t1 INNER JOIN TableName AS t2 ON t1.Key = t2.Key

Posted 11-Aug-14 20:14pm

Maciej Los

Comments

u mani 12-Aug-14 2:30am

Dear Maciej thanks for reply ,how to update this automatically every day please help me

Maciej Los 12-Aug-14 2:32am

Create a job!

u mani 12-Aug-14 2:33am

please tell me the process to create a job .

Maciej Los 12-Aug-14 3:19am

Follow the link i provided.

u mani 12-Aug-14 3:42am

ok thank u please provide

Amol_B 12-Aug-14 4:51am

You want everything ready ? Does Google not work on Your Machine?

Maciej Los 12-Aug-14 9:11am

Have a look at my past comment: "Create a job" is a link ;)