Dears,
I am facing one issue in my below query trying to do the calculation and pass the value in new column but getting like below.
My Query
CASE WHEN '' = '' THEN credit_amount * 0.0299 ELSE '0.00' END AS TexValue, CASE WHEN '' = '' THEN credit_amount / 1.15 ELSE '0.00' END AS TXTVAT,
Error
Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to numeric.
Completion time: 2024-01-21T09:47:02.4563341+03:00