Yes. In SSIS, you have access to C#, allowing very sophisticated levels of manipulation to be accomplished. But...

Thanks, Jeff. I made the assumption that the OP did not have a table 'TBL' containing a single column 'COLUMN1' and therefore that the addition of a suitable PK would...

Another version:

SELECT t.COLUMN1
      ,STRING_AGG (s.Item, ',') WITHIN GROUP(ORDER BY s.ItemNumber DESC)
FROM @TBL t
    CROSS APPLY
(SELECT * FROM dbo.DelimitedSplit8K (t.COLUMN1,...

Frederico, Des thank you both for the examples. Taught me something new … appreciated.

Please script...

Also, if the %of duplicates is higher than the % of singles, then it may be better to copy the singles into a new table and switch out the...

You could also include a copy of the query here (use a Code block for formatting)

People here will need a lot more information before they can provide any sort of detailed assistance.

A good starting point will be to paste a copy of your actual execution...

It would be helpful if you could post your test data in consumable format, eg

DROP TABLE IF EXISTS #SomeTab;

CREATE TABLE #SomeTab(...)

INSERT #SomeTab(...)
SELECT ...

and also show us what...

SELECT * FROM #tbl_datafile_list WHERE Autogrow LIKE '% restricted %'

Not a dumb question at all. In my opinion, MS is not focusing at all on SSIS/SSAS.

If you have the choice of what to learn, Azure and DataFactory are the...

Fair enough. I thought I had that error not long ago, and the reason was I had 'auto-pause' turned on for a particular Azure SQL DB and it had dozed...

That looks like an Azure security error to me, not related to Schema Compare.

Some practical examples of where Python beats standard SQL Server functions would be interesting. Or is this aimed simply at people who prefer writing their code in Python?

Is your question: "How do I create a report in Power BI which looks like my existing Excel solution?"

If so, it looks like a Paginated Report would be the...