I've found that I really don't need all of that stuff for SQL Server.  xp_LoginInfo and sp_validatelogins usually provide what I need.  If not, then I go to the Windows...

Please learn what a table is. First, we need to fix your non-table.

CREATE TABLE Expenses (emp_id CHAR(10) NOT NULL, pay_date DATE NOT NULL, -- read ISO-8601 formats expense_type VARCHAR(30)...

I suspect a couple of accidental CROSS JOINs is the issue.  Please run the following code and post the results.

 SELECT  f1_AllCount = COUNT(f1.PartId)
  ...

Ah... I see  what you mean.  Guess I'll have to look up how to do a "StaNine" and see if I can make a function or a GP proc for...

That procedure just calls some individual functions used to get each Stanine.

If you are looking for a formula for determining the bellcurve, we pay for studies to be done...

It has one big select statement that besides tables also joins one view and one table-valued function. It does not have explicit transaction.

But what I can do about blockings?...

It would still be nice to know the need for this particular format. ...

Any chance of us getting a peek at your "StaNine" stored procedure?

It's funny how people rail against duplicates in a randomly selected set... it's a part of what "random" is.

What’s happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.

Is that site dead now or is Redgate...

Also, Azure SQL Database is backed up for you. Further, there is no capability for you to do a traditional backup. Instead, you can create what's called a bacpac,...

Thanks, Johan.

@Thierry,

Thank you for the kind words... it helps MY imposter syndrome. 😀

Your internet speed is why I'm suggesting a local backup to a different local machine and then have that do the upload to Azure.  It keeps SQL Server...

1) create below mentioned table:

Material (materialid, supplierid, tenantid,mcode, is active, createdon) value is the date and time in which row is inserted.

uniquekey (mcode, tenantid)

,isactive is Boolean type and createdon...