How to increment the tenth decimal value

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 2005 Forums

Transact-SQL (2005)

How to increment the tenth decimal value

Author

Topic

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2010-04-22 : 10:11:27

How to increase tenth decimal value: if i have value 1.01 then it should get incremented to 1.02, 1.03, 1.04 etc

if i get a value @SeqNO: 2.03 then it shouod put 2.04

I get this value from table now for new record the incremeneted value to be saved, is it possible in the sql server SP?

Thank you very much for the helpful info.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-22 : 10:14:12

do you mean this?
@SeqNo + 0.01

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2010-04-22 : 10:21:04

Oh.. thats all.
this is quick.

so as long as i pass 2.00then it will be become 2.01

Perfect Visakh thank you very much.

quote:
Originally posted by visakh16

do you mean this?
@SeqNo + 0.01

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-22 : 10:24:13

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources