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 ('(./MM)[1]','varchar(100)'),mm.XMLResults.value ('(./MM)[1]','varchar(100)')))

AS MEDICAL_MM, ISNULL (mm.XMLResults.value ('(./TPERIOD)[1]','varchar(100)'),mm.XMLResults.value ('(./TPERIOD)[1]','varchar(100)'))AS T_PERIOD

from OVT_RESULTS CROSS APPLY XMLResults.nodes('/row[TITLE = "MM"]') as mm(XMLResults) where QueryID = 105) A

group by QueryID, DatasetID

Thanks again.. 🙂