Case "Error converting data type varchar to float.

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Case "Error converting data type varchar to float.

Author

Topic

jarisepp
Starting Member

1 Post

Posted - 2009-03-11 : 08:30:10

I'm trying to return data from different columns depending type defined for the data:


SELECT	
		dbo.Property.PropertyName,
		dbo.Datatype.TypeName,
		CASE dbo.Datatype.TypeName
			WHEN 'Integer'	THEN [Integer]
			WHEN 'Float'	THEN [Float]
			WHEN 'Date'	THEN [Date]
			WHEN 'Text'	THEN [Text]
			ELSE 
			'Unknown Datatype'
		END AS Value

FROM	dbo.Property 
	INNER JOIN dbo.Datatype ON dbo.Property.DatatypeID = dbo.Datatype.ID
	INNER JOIN dbo.RowValue ON dbo.Property.ID = dbo.RowValue.PropertyID

I got error message "Error converting data type varchar to float."

Is it possibble to return data from conditional column?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-03-11 : 10:04:36

[code]SELECT dbo.Property.PropertyName,
dbo.Datatype.TypeName,
CASE dbo.Datatype.TypeName
WHEN 'Integer' THEN CAST([Integer] AS VARCHAR(255))
WHEN 'Float' THEN CAST([Float] AS VARCHAR(255))
WHEN 'Date' THEN CAST([Date] AS VARCHAR(255))
WHEN 'Text' THEN CAST([Text] AS VARCHAR(255))
ELSE 'Unknown Datatype'
END AS Value
FROM dbo.Property
INNER JOIN dbo.Datatype ON dbo.Property.DatatypeID = dbo.Datatype.ID
INNER JOIN dbo.RowValue ON dbo.Property.ID = dbo.RowValue.PropertyID[/code]

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources