No, this is not...

If you can recreate the issue in a test environment, can you try removing the index, performing the problematic insert & then looking at the results?

Or could the source data...

Rather than setting the column types, I suggest you add a data conversion component after the source to convert from source to target datatypes. It is these converted columns which...

Thank you for elucidating. It's a really interesting problem.

Bravo, Neil!

Wow, you've obviously had a lot of 'fun' with this, well done!

Suggesting that image files are not compressed is, however, incorrect. They are heavily compressed, just not using Zip.

Not a direct solution, but have you considered creating a temp table to hold the results of running sp_whoisactive, then doing an

INSERT #SomeTable
EXEC sp_whoisactive

followed by whatever filtering...

Scott's solution uses zero temp tables.

You want me to write your queries for you, despite not having provided DDL and consumable sample data yourself?

If you understand the principle behind what I have suggested, you should...

I suggest that you push the results of query 1 into a temp table, with an additional column

Id INT IDENTITY(1,1) PRIMARY KEY CLUSTERED

Then add a ROW_NUMBER() column to query 2...

• This reply was modified 2 years, 3 months ago by Phil Parkin.

What is 'Cabot'?

Makes sense, thanks for clarifying.

I don't see that. If I run the following, it executes just fine.

DECLARE @Language NVARCHAR(10) = N'en';

DROP TABLE IF EXISTS #Temp;

CREATE TABLE #Temp
(
    TestName...

I shall address the...

Looking on the bright side, maybe the Dark theme would have been officially implemented in that...