Home » SQL & PL/SQL » SQL & PL/SQL » error converting datatype varchar to float (SQL Server 2005 Enterprise edition + windows server 2003)
error converting datatype varchar to float [message #338072] Sun, 03 August 2008 01:51 Go to next message
Messages: 51
Registered: July 2008
Location: India

SELECT     AVG(CONVERT(float, responsecode)) AS 'Average Score', 'Location' AS Expr1, 

location AS Location, 1 AS ord
FROM         ReportSMSSurvey
WHERE     (responsecode IS NOT NULL) AND (responsecode IN
                          (SELECT DISTINCT levelactualvalue
                            FROM          ResponseLevel
                            WHERE      (levelactualvalue IS NOT NULL))) AND 

(requestreceivetime > CONVERT(datetime, CONVERT(char(10), '06/01/2008', 101), 101)) AND 
                      (requestreceivetime < DATEADD([day], 1, CONVERT(datetime, 

CONVERT(char(10), '07/30/2008', 101), 101)))
GROUP BY location

hi i am running the following query but it's given me the bellow error

error converting datatype varchar to float

but there are all numbers the query is returning.

i m not able to track the error.

please help me with the same,

what are the possible reason of this error

Re: error converting datatype varchar to float [message #338074 is a reply to message #338072] Sun, 03 August 2008 02:00 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT Oracle SQL.
This site is for Oracle questions only.

Previous Topic: email not delivering from pl/sql
Next Topic: comparing values in a table
Goto Forum:

Current Time: Thu Jul 27 23:55:21 CDT 2017

Total time taken to generate the page: 0.12482 seconds