SQL Server Sum rows with string value - Stack Overflow

I have a dynamic SQL query which returns rows like below with string values ... You can use a CASE Expression to determine whether the value is a number.

stackoverflow.com