Looking back at this, I finally found a decent use for DATEDIFF_BIG... it's to create UNIX TimeStamps of both the "seconds since 1970" and "milliseconds since 1970" flavor (the later...

Which version of SSMS?

You're running your local SSMS and not SSMS in Docker, right? If so, you should be looking at your local path, not in the docker container. Templates...

I try to always use procs. I don't know of a good reason not to. It's visible, editable , & reviewable in superior query-editing tools such as SSMS. And it's...

You're getting the duplicates because M2 has two parents -- P2 & P3.

If you don't care about that and need the single row for each such case you'll need to...

Two potential values  of the Oracle-style ROWTYPE over an MSSQL user-defined table type:

• The ROWTYPE stays in synch with the table on which it's based -- it requires no maintenance....

Create a stored procedure WITH EXECUTE AS OWNER.

(being sure to secure the procedure so only the intended people can execute it)

Have you tried wrapping SUM(Amount) w/ ISNULL? e.g.,

 , [Amount]= ISNULL(SUM(Amount),0)

??? SP3 was released in September 2021.

https://www.microsoft.com/en-us/download/details.aspx?id=103440

You can reuse local temp tables from one stored procedure in a procedure called by the proc that created the temp table, because they are in the same session.

e.g., get...

Global is global. So, yes they could certainly conflict & return bogus data.

I'd recommend using local temp tables instead of global temp tables, or staging tables within the appropriate databases.

I...

The USE statement is for specifying database to use on the connected server, not for specifying a server.

You need to define & use a linked server (the definition would...

"AppVManagement"  & "AppVReporting" appear to be for Microsoft Application Virtualization: https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-for-windows, https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-deploy-appv-databases-with-sql-scripts

ReportServer & ReportServerTempDB are for SQL Server Reporting Services.

Note: This appears identical to a question that was asked on...

Do you know/can you determine if a big transaction occurred just prior to this problem?

Are you out of space? How much disk space is used and how much is available...

Do you have replication on that database?

Have you executed DBCC CHECKDB to check for errors? If it indicates errors, see this: https://www.sqlservercentral.com/articles/help-my-database-is-corrupt-now-what. Do not reflexively run repair w/o fully...

Those three have approximately 2/3 of the market, and are mostly (ServiceNow at #3) the fastest growing.  The top eight have 82% of the market. If you're in/find an industry...