Format could be derived like this:

CONVERT(CHAR(10),jobstarted,103) + ' ' + CONVERT(CHAR(8),jobstarted,108)

You indicate output as "Rome Time". What timezone/offset is your source data in?

Were Windows updates installed?

Sounds like a query or data issue. Do the affected reports have anything (e.g, a parameter) in common?

Did something change in stored procedure(s)? New data that might...

They need to get their lawyer on the phone with the application provider.

The application provider seems incompetent at best, and probably unscrupulous and/or struggling to survive with outdated technology. Your...

e.g.,

DECLARE @SNH TABLE
(
cntDT DATETIME,
cntQ varchar(10),
cntL int
);

INSERT INTO @SNH (cntDT, cntQ, cntL)
VALUES ('2001-04-04 10:00:00', 'Queue01', 3),
('2001-04-05 10:03:00', 'Queue01', 1),
('2001-04-05 10:06:00', 'Queue01', 1),
('2001-04-05 10:07:00', 'Queue01', 1),
('2001-04-05 10:11:00', 'Queue01', 1),
('2001-04-05...

It sounds like you just need to use a numbers table or tally function to generate numbers, & use that to generate table of datetimes using DATEADD.

Not sure...

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