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 1 years, 6 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...

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

You've got some fun R&D lined up.

This won't be a password thing. Instead you'll be using OAUTH2 to gain access and messing about with ClientIds, ClientSecrets and Access Tokens, I...

loaded question but i'll try.  for starters we plumb more than just pbi to cubes.  for example excel pivots.   i understand there is an extension to excel called power...

Hi

I am New To Azure Sql.  Can some one please share

•  If we can migrate sql 2017 db with symmetric key and certificate in it on Prem to Azure...

As the term 'perfect' is poorly defined in the context of software, one person's 'perfect' is another person's 'not bad'.

I don't remember ever using software that I didn't think could...

It is, indeed, a tricky one. Surrogate keys + date logic looks like the way forward.

It's not an elegant star schema model.

I hope that others respond with their ideas.