Hello Everyone,

Thank you so much for all of your inputs. I managed to make the query work but doing this:

SELECT QueryID, DatasetID, SUM(MEDICAL_MM) FROM

(SELECT QueryID, DatasetID, convert (numeric,ISNULL (mm.XMLResults.value...