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 |
|
shm
Yak Posting Veteran
86 Posts |
 Posted - 2009-02-09 : 07:16:36
|
| hiin the query select 1/8 i wanted to get the result to the query as 0.125 but if i run this it is coming as 0 wt changes i want to do? |
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2009-02-09 : 07:21:35
|
| select 1*1.0/8Jai Krishna |
 |
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2009-02-09 : 07:23:21
|
| Or Use CAST or CONVERT select cast (1 as numeric(18,3))/8 select convert(numeric(18,3),1)/8Jai Krishna |
|
|
|
shm
Yak Posting Veteran
86 Posts |
Posted - 2009-02-09 : 07:42:53
|
| thank u very much it is working..y it is mulitply 1.0 |
|
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2009-02-09 : 07:49:58
|
| To Cast to float valueJai Krishna |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
sql query