Didn't have any coffee yet, but selected the right (wrong) answer..

If I read this  this article the result should be -21.

Louis.

This question is one year late,  DBCC TIMEWARP() ??

Setting the date is depending on the language/region setting of SQL server.
he server I tested on interpreted the string '10/02/17' as February 10th, DATENAME returned 10.
I picked the...

Instead of adding the extra columns later :

SELECT TOP (0) 
       *,
       [FileName] = CAST(null AS varchar(60) ),
      ...

To extract nodes from an xml with namespaces, look at this site: xmlnamespaces,
I can't try with your namespace without sample data
Regarding missing nodes, using the value...

You could use a recusive cte,

Changed the Id in your sample to Group_Id and added an Identity_Column to enable filtering and sorting.

The first cte filters and sorts the data...

Steve, your explanation tells me I'm right, but the result tells me false....

Did you try to Stretch us and run into the limitations of the QOTD ?

Louis.

This code checks for existence of the column and drops it.

IF EXISTS (

SELECT 1

...

VARDECIMAL is a storage format, not a datatype...

pls my point..