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