Is there a specific question there, or are you...

Hi Guys

I need to write a procedure to validate an SA identity number (a SSN in the west).  Please look at the attached doc for a detailed explanation.

Thank you...

Deleted

• This reply was modified 5 years, 1 months ago by Phil Parkin.

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