Also, 'User Management' potentially sounds like something which should be handled by a single database.

Having a single database for all of the applications sounds like a bad idea – what if one app has to be restored but the others don't?

One DB per app...

Something like this?

CREATE TABLE #SomeValues (SomeData VARCHAR(50));

INSERT #SomeValues (SomeData)
VALUES
('1101BRZ')
,('BRZ')
,('    1101BRZ')
,('   BRZ    1101')
,('    INSP');

SELECT
   ...

You have >1000 points and therefore should know by now – please provide DDL and sample data to match your desired results.

If you do each iteration in a branch and only merge those Jira items you want to promote into Main prior to deployment, you can generate a script by...

Great! Thanks for posting back.

STRING_AGG() is your friend here, but the fact that it does not support DISTINCT (eg, to avoid John/John/David) complicates things somewhat. Here is one solution.

DROP TABLE IF...

The format I had been using in Excel is:  Format Cells --> Custom --> m/d/yyyy h:mm:ss

Excel technically only lists the custom format as:  m/d/yyyy h:mm and I add the...

Taking SQL Server out of the equation for a moment, can you find a data format which Excel interprets the way you want, on pasting?

Once you have that, post it...

Can you post the (sanitised as needed) definition of the TVF which returns the MemberIds to which the user has access?

How is the list of members which a user is permitted to see defined?

Does the members table have a clustered index on MemberId (or whatever you have chosen to call...

I see no 'nested loops' here. What do you mean? Looping in T-SQL would require the use of something like WHILE ...

Are you happy that this query may occasionally return...

... but is this command trying to execute SecureZip on the server and the error is saying the application is not installed on the SQL Server?

Precisely this.

I stated that your sample data did not include EmpId 480.

That statement was correct now and remains...

not supported by Microsoft and against licensing rules to install a Client only application on a server.

I found the following text here:

Besides the technical problems, you must also consider...