![sql server - T-SQL :: Error converting data type varchar to numeric when changing 1 to 0.5 - Stack Overflow sql server - T-SQL :: Error converting data type varchar to numeric when changing 1 to 0.5 - Stack Overflow](https://i.stack.imgur.com/dlA1A.png)
sql server - T-SQL :: Error converting data type varchar to numeric when changing 1 to 0.5 - Stack Overflow
![SQL SERVER - Error: Msg 245 - Conversion failed when converting the varchar value 'Inactive' to data type int - SQL Authority with Pinal Dave SQL SERVER - Error: Msg 245 - Conversion failed when converting the varchar value 'Inactive' to data type int - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/a/case-when-01.jpg)
SQL SERVER - Error: Msg 245 - Conversion failed when converting the varchar value 'Inactive' to data type int - SQL Authority with Pinal Dave
![database - How to avoid rounded integer while converting from string with decimal point to NUMERIC.? - Stack Overflow database - How to avoid rounded integer while converting from string with decimal point to NUMERIC.? - Stack Overflow](https://i.stack.imgur.com/oNJ4r.png)