That's OK, but it's best to be clear about that so that volunteers know not to recommend platform-specific (TSQL) solutions.

Here's a tek-tips Pervasive forum: https://www.tek-tips.com/threadminder.cfm?pid=318

A calendar table is great for that.

But if you want to derive it dynamically, and you're always executing on the day following the end of the date range:

            
May 11, 2022 at 9:06 pm
            
#4031425

            
            
                                                
        

PSQL? Are you using postgres? You posted in a SQL Server 2019 forum.

Joe Celko's Trees and Hierarchies in SQL for Smarties -- Treason hierarchies is a whole different topic 🙂

Auto-correct did a number on your post, Joe.

If you're not seeing it via direct group membership, look at nested groups (user is a member of a group that is a member of another group that has database...

Do any Windows domain groups have SQL Server Windows logins/database access?

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