Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Calculations in SQL


What data ype manipulations do I need to apply to get 'select 10/100' giving
me a result of 0.1 instead of 0

--
obelix

"Whether you think you can or you think you cant you are right"  .... Anon

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/2007...

Hi,
Convert the 100 to a numeric of whatever size you want

select 10/convert(numeric,100)

-
Greg O
SQL Server Documentation the easy way
SQL 2000, SQL 2005 the best is back
http://www.geckoware.com.au/Content.aspx?Doc_id=1001

"obelix via SQLMonster.com" <u24035@uwe> wrote in message
news:72e3dcde8af66@uwe...

On May 29, 12:33 pm, "obelix via SQLMonster.com" <u24035@uwe> wrote:

> What data ype manipulations do I need to apply to get 'select 10/100' giving
> me a result of 0.1 instead of 0

> --
> obelix

> "Whether you think you can or you think you cant you are right"  .... Anon

> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/2007...

select 10/100.00
Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc