All the EXEC statements are commented out. I presume so you can run it, check the SQL it would have executed and then either execute it manually or uncomment the...

DECLARE...

I'd get rid of the union alls entirely, they're defeating the purpose of using Grouping Sets, and just have WHERE ID IN (1,2,3). You may also want the GROUP BY...

Using row_number() can be problematic if the data can change between each individual request. There are different types of solution, which can all have different pros/cons depending on the precise...

select kd
from
(
 select kd from table1
 intersect select kd from table2

July 29, 2018 at 3:45 am

#1999384

I believe you can slightly extend that by moving to Azure hosted SQL 2008, but honestly it might be better to plan a migration to a newer SQL Server release

Indeed. And how you solve the problem if you do care might depend on if you have a single table you need to beck up, or a whole raft of...

DDL will definitely help people to help you. You might want to investigate the FORMAT function which can probably help you get where you're trying to go, eg:
[code...