DECLARE @xml1 AS XML = '<SourceXML>
<valveData.valveID>16523</valveData.valveID>
<measurementData.parentTableName>valveData</measurementData.parentTableName>
<measurementData.structure>16523</measurementData.structure>
</SourceXML>';
DECLARE @xml2 AS XML = '<SourceXML>
<valveData.valveID>16863</valveData.valveID>
<measurementData.parentTableName>valveData</measurementData.parentTableName>
<measurementData.structure>16863</measurementData.structure>
</SourceXML>';
SELECT (checksum(CONVERT([nvarchar](max),@xml1))), (checksum(CONVERT([nvarchar](max),@xml2)));