Perhaps this will provide what you are looking for 
sys.dm_exec_describe_first_result_set_for_object

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...