Excellent detective work there. I had not realised that file association arguments were stored like that in the Registry.

Unfortunately, it won't. It will instead try to execute locally.

But all is not lost, you can use Powershell Remoting...

Are you hoping that the script will execute on the remote server? Or is that just the place where you store PoSh scripts?

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