You need to create an additional variable with forced values for the NULLS.

--Create the dynamic date columns string
declare @cols AS NVARCHAR(MAX)
declare @vals AS NVARCHAR(MAX)

This seems to be the simplest form of the OP's requirement.

SELECT columns
FROM table
WHERE TYPE <> 14
 OR VISIBLE = 0;


Reported as spam

Is the index on a UNIQUEIDENTIFIER column?

You keep changing the XML.  In one post it has a namespace, in the next it has an xsd.

Based on the latest sample, this will work
[code...

I believe that this will meet your requirements

WITH T(N) AS (SELECT N FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS X(N))
, NUMS(N) AS (SELECT ROW_NUMBER() OVER (ORDER BY...

I am currently unable to test this solution,
But I believe the syntax to be correct.

WITH XMLNAMESPACES('http://schemas.microsoft.com/sqlserver/2006/03/15/reporting/reportingservices' AS rs)
, getxml AS (
...

Is this table possibly used as a staging area for processing data.
If it is, are many deletes, and no truncate?  That would be one scenario where the IDENTITY gets...

reported as spam