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 5 months, 2 weeks 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...

SSMS keyboard shortcuts (built-in and custom) are working as usual for me in 20.1.

What do you mean by the following, exactly?

It seems to always wait for the second character in...

Not exactly by hand. Intellisense identifies them.

June 12, 2024 at 2:46 pm

#4428030

didnt know.  so answer #2,  kind of piling on answer #1 is that the users who pivot would need minimally a pbi pro license.   i dont think we want...

There is no column ZZZZ in table a. The only column in table a is a

create table a (a int) would need to change to create table a (ZZZZ...