Second link w/ a google search: https://docs.microsoft.com/en-us/sql/sql-server/install/work-with-multiple-versions-and-instances-of-sql-server?view=sql-server-ver15

Is that the only change to the script? What reporting tool?

Can you provide DDL for the tables including indexes? See How to Post Performance Problems

Get an actual execution...

It sounds like you are trying to spell check existing data.  Do you also want to validate incoming data? If so, how does it come in? SSIS or other ETL tools?...

If you're talking geography, this provides a method to get direction using lat/long: https://stackoverflow.com/questions/14736464/determining-cardinal-compass-direction-between-points

Here's one that is supposed to calculate bearing between two points: https://www.spdba.com.au/cogo-calculating-the-bearing-between-two-points-sql-server-2008-spatial/

Note: Given origin/source & destination points,...

You can use a tally function,  number table, or similar to get a selected  # of rows to generate -- e.g.,

USE [DBA]
GO
DECLARE @fquantity INT = 50
SELECT...

I don't - I get '000' if @max_naam = '22'. Does @MAX_naam really need to be varchar(max)?

DECLARE @MAX_naam AS varchar(MAX) = '22'
DECLARE @maxnaam_length AS int = LEN(@MAX_naam);
DECLARE...

DECLARE @zeroes AS varchar

If you declare a variable or parameter as varchar w/o specifying length -- e.g., varchar(5) -- it is implicitly declared as varchar(1), and can...

You should probably start w/ determining what is using the most memory, & seeing if there opportunities to tune expensive queries via better indexes and/or more efficient queries.

Beyond that, the...

SSRS is for reporting existing data, not for data input.

Are you trying to generate (semi-) blank forms that can be printed for somebody to write in (or, I suppose edit...

It sounds like you were CPU-bottlenecked, and since that is addressed, now you are memory constrained.

Are you using Enterprise Edition? What else do you have running on the VM?

92GB is...

https://aws.amazon.com/blogs/aws/new-gpu-powered-amazon-graphics-workspaces/

https://aws.amazon.com/pm/work

https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/elastic-graphics.html

https://aws.amazon.com/blogs/compute/building-a-gpu-workstation-for-visual-effects-with-aws/

https://pages.awscloud.com/ec2-virtual-workstations-media-entertainment.html

Given a tally/number table or function (e.g., https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally):

DECLARE @year INT = DATEPART(YEAR,GETDATE());

SELECT 
    DATEFROMPARTS(@year,Numbers.Number,1) AS FirstOfMonth, 
    DATEADD(month, DATEDIFF(month, 0, DATEFROMPARTS(@year,Numbers.Number,1)) + 1, -1) AS...

SQL Server has no idea where the logged-in user is - TSQL is execute on the server, not the client.

If you want this information for SQL Server, you will have...

You didn't post the function.

Right now, you're missing the entire query

🙂