Have you checked it returns the same results?

You are thinking LEFT JOIN works like OUTER APPLY (it doesn't). You can rewrite the first query using OUTER APPLY instead of LEFT JOIN:

SELECT Grades.[Name] AS Grade,
...

I asked ChatGPT:

WITH RankedEmployees AS (
  SELECT
    employee_id,
    employee_name,
    department,
    joining_date,
   ...

This appears to be a classic "Next_ID" table and I find it difficult to understand why anyone would be using such a thing in this day and age, especially...

I would indent the query like this:

FROM CHG
LEFT JOIN CAMCHARG CC  
     LEFT JOIN CAMRULE CR    
  ...

Look at the files on the drive and see if there is a large, obsolete file(s) (perhaps old backups?).

Depending on the version of SQL Server, you...

Look at the files on the drive and see if there is a large, obsolete file(s) (perhaps old backups?).

Depending on the version of SQL Server, you might also...

Hi,

I am not very familiar about how sql server works behind the scenes but could it be that my query results are being saved somewhere on my local drive...

Just to add to the previous comments. I upgraded a system from SQL 2012 to SQL 2019 RDS on AWS. One of the most impactful actions after identifying...

Just to add to the previous comments. I upgraded a system from SQL 2012 to SQL 2019 RDS on AWS. One of the most impactful actions after identifying slow-running queries...

SELECT 
    CASE 
        WHEN DATEDIFF(SECOND, crtDte, GETDATE()) < 60 THEN 'Just Posted' 
   ...

Oh yes, I was looking...

UPDATE MM2WO
SET sDesc = TRANSLATE(sDesc, '&<!>!-=', '      ')
WHERE ...

https://learn.microsoft.com/en-us/sql/t-sql/functions/translate-transact-sql?view=sql-server-ver16

Check the 3 underlying views.  If they're all pulling from the same tables, it might be worth while to crib some of the code and write a...

Check the 3 underlying views.  If they're all pulling from the same tables, it might be worth while to crib some of the code and write a separate query,...