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 |
|
S4N44
Starting Member
2 Posts |
 Posted - 2007-12-02 : 11:37:11
|
Hi,declare @myvar decimal(5,2)set @myvar = 100/3print @myvar This returns 33.00 I actually want it to return 33.33Could anyone please help me ?Thanx in advance.Regards. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-02 : 11:40:06
|
[code]declare @myvar decimal(5,2)set @myvar = 100.0/3.0print @myvar [/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
S4N44
Starting Member
2 Posts |
Posted - 2007-12-02 : 11:58:33
|
THANX a lot !  |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-03 : 01:47:07
|
quote:
Originally posted by khtan
declare @myvar decimal(5,2)set @myvar = 100.0/3.0print @myvar
KH[spoiler]Time is always against us[/spoiler]
Keeping either one decimal is enoughdeclare @myvar decimal(5,2)set @myvar = 100.0/3print @myvar MadhivananFailing to plan is Planning to fail |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-03 : 01:54:04
|
quote:
Keeping either one decimal is enough
kiasu 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-03 : 03:15:50
|
quote:
Originally posted by khtan
quote:
Keeping either one decimal is enough
kiasu
KH[spoiler]Time is always against us[/spoiler]
MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
returning decimal