Thursday, September 5, 2013

Problem >> SQL : Error converting data type varchar to numeric .
Solution>> Check for any string concatenations in your returning value of sql query .
ex: ((total-used)/total)*100 +'%' As percentage this try to convert varchar to int and thats the problem ,
If this dosent work try casting
SELECT CAST(Mydate AS datetime) AS [Login Date/Time], Uname AS [User Name] .....etc.

No comments:

Post a Comment