The WHERE clause has to precede the GROUP BY CLAUSE -- where filters data before it is aggregated

SELECT...
FROM...
JOIN...
WHERE...
GROUP BY...
HAVING...
ORDER BY...

Why not use STRING_SPLIT?

The spaces around the slash complicate it slightly since STRING_SPLIT accepts only a single-character delimiter, but as long as the spaces are consistent, you can handle that...

I suspect you meant "...relational databases are not going away."?

MySQL functions --

DATE_SUB(CURDATE(), INTERVAL 7 DAY)

-- won't be of much use on SQL Server 2019.

Not aware of any property that can be automatically read.

As an alternative, could you:

1. Rename table;
2. Create a view w/ the currently-used table name that excludes the deprecated columns; &

...

deleted

@P8 -- like all your improbably large/generic parameters -- is an nvarchar(4000). cid can't possibly be nvarchar(4000) and have an index/primary key -- it's too large to  be indexed. The...

Are you trying to reduce backup size and duration? Trying to improve performance? Are you trying to reduce cost by archiving to cheaper storage? Will the archived data realistically be...

One way would be to have an assignment # column in the association table -- e.g. AssignmentNumber. Use tinyint. And create a check constraint that limits AllocationNumber to 1 through...

It generally matters little, if at all -- the optimizer should be able to use statistics to order the predicates optimally.

Far more important are statistics and indexing. Without an appropriate...

No: "Scalar functions must be invoked by using at least the two-part name of the function (<schema>.<function>)"

Why are you even trying to work around this? You should preface all...

I actually tried it that way prior to the where clause way.  It does work, but the update will update all the matched records since there is no filter on...

We don't have your fn_GetAlphabetsOnly function -- that's a user-defined function.

The following returns EMA_T__MRNMM_PMSPAT_PID_OR_Dr:

DECLARE @string VARCHAR(255) = 'EMA_20210526T211254_0000_MRNMM0000001240_PMS110460PAT000001287_PID15235307_OR_Dr'
SELECT @string,REPLACE(@string,'%[^0-9]%',''), REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@string,'0',''),'1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9','');

Note: Your sample results don't seem to reflect...

Prior post referencing S.O. was flagged as spam?!?, so here's an abridged MSSQL version w/o links:

SELECT [Number], [Cost],
(SELECT Max(v) FROM (VALUES (date1), (date2), (date3)) AS value(v)) as...

Is it possible before it complete the backup of the one database it will start another database backup?

SQL Server Agent will not start another instance of a job if job...