float to decimal without rounding

microsoft.public.sqlserver.programming

23 Sep 2005 12:12 AM

Disney

select 'Customer_Greeting_Section_total'=
Case when
Customer_Greeting_Section_total is null then 0.00
else left (ROUND(Customer_Greeting_Section_Total , 2, 1),4)
end

from DTSTEMP1

The col is defined as float

When I run this I get

Server: Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.

23 Sep 2005 7:31 AM

John Bell

Hi

It is not clear why you are using left, as this a string function as doing
this may be meaningless. Removing the left function will (probably) stop the
error. See http://www.aspfaq.com/etiquette.asp?id=5006 on how to post DDL and
example data will help to solve your problem. Posting your desired results
from the query is also useful.

John

Show quote

"Disney" wrote:

> select 'Customer_Greeting_Section_total'=
> Case when
> Customer_Greeting_Section_total is null then 0.00
> else left (ROUND(Customer_Greeting_Section_Total , 2, 1),4)
> end
>
> from DTSTEMP1
>
> The col is defined as float
>
> When I run this I get
>
> Server: Msg 8115, Level 16, State 8, Line 1
> Arithmetic overflow error converting numeric to data type numeric.