The HDFS component is available from a native installation of SSIS and does not require the installation of a Hadoop server.

The HDFS connection manager allows SSIS to connect to the...

Or add the IDENTITY after the SELECT INTO

SELECT TOP (10) * INTO #Test FROM sys.columns c

ALTER TABLE #Test ADD SomeId INT IDENTITY(1,1)

SELECT * FROM #Test t

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