Return to Question

I adopted a script from a link below, but it seems to work with known columns. Can it be done for an unknown number of columns (like SELECT * does)? I mean I have multiple tables, and I really don't want to use dynamic SQL or write tens of stored procedures to implement MergeTable1, MergeTable2 and so on.

Table is large enough (several tens of columns, several hundreds of thousands rows), so it's desired to do it in single table scan (if possible).

Table is large enough (several tens of columns, several hundreds of thousands rows), so it's desired to do it in single table scan (if possible).

I appreciate any help and any possibility to achieve it without any bias, SQLCLR, DSQL and so on, everything is applicable if it works fast and makes its job.

In this example table is small and has only 5 columns, but in real table it will be much larger. I really want this script to work fast. I tried do it myself, but my script works for SQLSERVER2012+ so I deleted it as not applicable.

Numbers: table could have 150k of rows, 20 columns, 20-80k of unique ids and average SELECT COUNT(id) FROM T GROUP BY ID is 2..5

Table is large enough (several tens of columns, several hundreds of thousands rows), so it's desired to do it in single table scan (if possible).

I adopted a script from a link below, but it seems to work with known rows. Can it be done for an unknown number of columns (like SELECT * does)? I mean I have multiple tables, and I really don't want to use dynamic SQL or write tens of stored procedures to implement MergeTable1, MergeTable2 and so on.

I adopted a script from a link below, but it seems to work with known columns. Can it be done for an unknown number of columns (like SELECT * does)? I mean I have multiple tables, and I really don't want to use dynamic SQL or write tens of stored procedures to implement MergeTable1, MergeTable2 and so on.