Also missing the comma between the surname and the date of birth

No the command line tools are not installed with SSMS, they are installed with the full version of SQL.  If you need to cmd tools you will need to install...

When you select each individual component it should detail that the patch for piece except SSRS is installed, so while the whole thing is selected it will apply the update...

Would be a case for LAG (https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15)

create table #rollingtotals (totdate date, totamt int)
insert into #rollingtotals (totdate,totamt) values
('2020-11-10',30),
('2020-11-21',60),
('2020-11-30',75),
('2020-12-20',110),
('2020-12-31',130),
('2021-01-27',140),
('2021-01-28',195),
('2021-01-31',250)

;with cte as(
select datepart(month,totdate) as mnt, datepart(year, totdate) as yr, ...

Have you installed the SSIS extension from the market place.

Along with the SSAS and SSRS extensions if you need those?

<2019 you have to install SSDT

>= 2019 you have to use...

The path to the UNC place needs to be double quoted

BCP Select * From [BI-EDW].EAP.EAP.vw_file queryout "\\bi-qservername\eap\Extracts\raw-can-mwia--file_ss-interval_20210123_20210124_dumpedon_20210124.csv" -S BI-EDW -d EAP-T -r"\r" -t "|" -c -C 65001 -e "\\bi-qservername\eap\Extracts\file_errors.txt"

Something, someone has already put that piece of information into the table, so you need to look at the logic and go back and see why you are trying to...

Thats down to only joining df1 and df2 on the host/pc column.  You have 4 different versions/names in df1.

What was to happen should the purpose change to "bye" for example,...

PRINT goes to the messages tab in SSMS as its information not data

If you want it in the data result pane or data set you would want to use SELECT...

These are the two reference sites I use for the list of available patches

https://sqlcollaborative.github.io/builds

https://sqlserverbuilds.blogspot.com/

As for the report I would do it from a central management server or use DBATools to...

You would need to make your SQL server public internet facing, which in this day and age is NOT a good thing to do with all the data breaches etc.

If...

What have you tried so far to debug?

The most likely solution for this is firewall configurations need putting in place.

ensure there is an exception for the correct tcp/udp ports in...

You using port 587 or port 25?

Also using smtp.office365.com as the smtp address?

A bit crude but essentially need to find a way to reverse the item number

DROP TABLE IF EXISTS #TmpData;
CREATE TABLE #TmpData (
Id INT NOT NULL IDENTITY(1,1),
Name Varchar(20)...

You need to use ODP.NET and I believe it has to be Oracle Client 18.0 for SSRS2019, don't quote me on that just from what I googled