Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jonekim
Starting Member
35 Posts |
 Posted - 2012-04-04 : 10:34:36
|
| I am designing a database in which the value of an item should be auto increased after continuous time.suppose I've an entity; interestRate whose value is initially 15 initially. Now after 10 days it should be 16 and go on increasing by unit value within the interval of 10 days.Can I do it with sql code? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jonekim
Starting Member
35 Posts |
Posted - 2012-04-04 : 11:53:30
|
| @ X002548.Thanks for the reply.ya sometimes it is tedious to manually update the values.in my case, the value of interestRate is increasing periodically not arbitrarily. Its increasing with time, unit increase in 10 days. Can i do it from sql or I've to use servlet programing(i am using C# and asp.net)? |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-04-04 : 12:53:49
|
| SQL Agent and a scheduled job.--Gail ShawSQL Server MVP |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
increment the value of an entity in period of time