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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-06-24 : 04:44:26
|
| HiI need a result of 1/3 as 0.3333 but select 1/3 as testreturns zero!! could you tell me how I can calculate inverse of a number and return as decimal?Thanks in advance |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-06-24 : 04:45:26
|
select 1.0 / 3
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-06-24 : 04:59:24
|
| Thank youuuuuuuuuuuuu :) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-24 : 09:10:18
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2008/01/16/beware-of-implicit-conversions.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Inverse Number