 | |
Re: Error converting varchar value '8.80' to a value of data type int
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Error converting varchar value '8.80' to a value of data type int -
07-21-2004
, 09:08 AM
|
While running a SQL query with the following line: sum( case when SgnSigField = 'PR4650' then SgnValue else 0 end) as EuAmount1, I get the following error: Server: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value '8.80' to a column of data type int. I have tried to cast the field: with NO success. Any advice is greatly appreciated Thank you, Kermit Baker II |
#2
| |||
| |||
|
|
While running a SQL query with the following line: sum( case when SgnSigField = 'PR4650' then SgnValue else 0 end) as EuAmount1, I get the following error: Server: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value '8.80' to a column of data type int. I have tried to cast the field: with NO success. Any advice is greatly appreciated Thank you, Kermit Baker II |
create table x
(x1 char(1),
x2 varchar(10))
go
insert x values ('a','80.5')
insert x values ('b','75.0')
insert x values ('a','80.5')
go
select sum(case when x1 = 'a' then cast(x2 as real) else 0.0 end)
from x
go
drop table x
go
The result is 161.0. Maybe using the 0 is implicitly an INT and, when mixed
with real or decimal(n,m) where m <> 0, causes additional conversion
problems?
I'd have used your column names and data types from your DDL in my example
but you didn't supply any DDL.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.