« first day (3755 days earlier)      last day (30 days later) » 

5:06 AM
@PaulWhite <sigh> once again Synapse is left in the dust. And I had to code precisely that a month or so ago. No hum.
 
5:33 AM
Well it's not even in real SQL Server yet, so don't feel too bad
 
 
9 hours later…
2:11 PM
user image
5
 
 
10 hours later…
11:58 PM
Man I never expected such a simple collision with CHECKSUM
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)));
 

« first day (3755 days earlier)      last day (30 days later) »