how to convert the output of sub query into numeric
How to convert the output of sub query into numeric? It’s a little hard to tell without the concrete table definitions, but I’m pretty sure you’re trying to compare different data types to each other. If this is the case you can make use of the CAST or the CONVERT function, for example: SELECT [rptName] … Continue reading how to convert the output of sub query into numeric