Wait wait wait...

you can only reference a CTE immediately following the declaration. Why do you need a CTE for this at all?  What are you trying to accomplish?

Select @localvariable = count(*) from server_cte

SELECT ServerName + ', ' AS 'data()'
FROM ServerList
FOR XML PATH('');

Mike... most of the answer that I found is right here...

DECLARE @g geography;  
 DECLARE @h geography;  
 SET @g = geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358...

That's an awful lot of points for someone who can't even post consumable data. I guess this is required reading then: Forum Etiquette: How to post data/code on a...

Sorry, missed the NVARCHAR. (The answer is in the same article, though!)

That was cheating-level easy... except you need a helper function, Jeff Moden's DelimitedSplit8K function. It's here https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-“csv-splitter”-function

Here's the SQL:

SELECT x.Item AS Category
 , COUNT(*) AS UseCaseCount
FROM 
(
 SELECT ID
  ,...

INSERT INTO OtherDatabase.Schema.Table (<field list>)

SELECT <field list>

FROM...

Or you could

INSERT INTO db.schema.table (field list)

EXEC storedProcName @param1='x', @param2='y';

The query will eliminate the sets that have already been added. That's what the NOT EXISTS predicate is for.

I guess if you don't like it, you could always write your...

I need every iteration increased by 5000 rows insert from temp table

Why not something like

SELECT TOP (5000) <field list>
FROM SourceTable st
WHERE NOT EXISTS (SELECT 1 FROM DestinationTable...

If you're doing an insert where you don't want the constraints checked, you can script out the constraints on the table, then drop them, do the import, then add them...

Did you actually install SSMS? The weird thing about the newer installers from MSFT is that all the pieces are separate. If you search for it, can you find this...

Don't think you can do that very easily with SSRS. the best I think you can do is to make the filters optional... Except you can't build complete filters through...

Too hard to just copy & paste your CREATE TABLE and INSERT scripts here?

Would be easier to help with some sample data... It can be completely fake, just representative.