Data type details:
a. Batch column (float,null)
b. ID1 column (float,null)
c. [Urgent Request] column (bit not null)
d. [Total of Lines] column (float null)
e. [Total Quote Value] column (money null)
f. [PO Value] column (float null)
Error:
Error converting data type varchar to float
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
I tried to convert columns to float but still I am getting data type conversion error.
Pls advise.
sqldba2013
ASKER
I am getting error in line 22 to 26.
Please correct my mistake in above sql query.
Jim Horn
>I am getting error in line 22 to 26.
Eyeball the column data types in tables #HW and #SVCSummary, and tell us if for any column the data type is different.
>Error converting data type varchar to float
I'm thinking that for a column #HW is a float, and for #SVCSummary it's a varchar.
I tried to convert columns to float but still I am getting data type conversion error.
Pls advise.