If you're going to create a temp table, at least make it temporary!

DROP TABLE IF EXISTS #sat_temp;

CREATE TABLE #sat_temp
(
    Domain NVARCHAR(255)
);

INSERT #sat_temp
(
  ...

EXISTS will do it. But as you have not provided consumable data, I can't code it for you.

WITH bunch
AS (SELECT caseid
          ,anotherid
          ,locked
   ...

First I want to thank anyone who takes a moment to help with this.  I really appreciate all the help I've gotten here over the years and I wish...

• This reply was modified 1 years, 5 months ago by Phil Parkin.

I've not heard of anything like that, not that I've looked.

But if you are able to pull together some sample data and desired results, someone here might have a go...

You can use CASE in ORDER BY and you can get variable sorting to work. You can also get round the varchar/numeric issue by using an expression in the ORDER...

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...