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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Single Update Statement

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-09 : 22:50:46
Chris writes "Is there a quick & easy way to update a database in such a way that it wll take an integer and increase it by 10%. I need to update a figure by 10% every day, but the only way i know how is by looping through every record, reading the integer into a recordset, then updating it.

Thanks in advance!"
   

- Advertisement -