Hi all,
I am trying to implement this in a view, and i recieve this error, any idea how to fix it?
SELECT Report_ID, Report_Name, Customer_ID, Username,
CAST(C1 AS NUMERIC(13, 2)) AS DA_ENERGY,
CAST(C2 AS NUMERIC(13, 2)) AS RT_ENERGY,
CAST(C3 AS NUMERIC(13, 2)) AS REGULATION,
CAST(C4 AS DATETIME) AS DA_VERSION,
CAST(C5 AS DATETIME) AS RT_VERSION,
CAST(C6 AS NUMERIC(13, 2)) AS RESERVE,
CAST(C7 AS DATETIME) AS REGULATION_VERSION,
CAST(C8 AS DATETIME) AS RSV_VERSION
FROM ISO.ISO_HR_DATA
WHERE (Report_Name = 'BL_DETAILS')
Msg 8114, Level 16, State 5, Line 2 Error converting data type varchar to numeric.
all the values are stored as varchar in the database.
thanks,