Skip to content
Advertisement

Arithmetic overflow error converting nvarchar to data type numeric in case query

I am trying to show the number of quotes won as a percentage of the total number of quotes in a time frame. For example. I have a total of 294 quotes and 173 of them are won. The result I am looking for is 59%.

I have the below query but it is returning the error:

Arithmetic overflow error converting nvarchar to data type numeric

Advertisement

Answer

Try

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement