OH... you want 1 contents.txt per directory.  That gets a bit more complicated, but still pretty easy in Powershell.  Basically, you will need to start by getting the directory list...

One thought (may not be possible) but what about using a windows account rather than a SQL account?

If that is not an option, SQLCMD can execute TSQL against a SQL...

It looks like you have the code already.  Just append "> Contents.txt" to the end of it.

If you don't want powershell, bat file can do it too with "dir /s...

It's all good!  Not sure if I've been mistaken for Pietlinden before, but I know my opinions on query hints are that they should be avoided.

And I agree about getting...

I can't speak on how ETL developer compares to SQL Developer in terms of level.  They are 2 different roles from my understanding.

The benefit of branching out is you get...

My opinion with regards to performance - test it out!

In theory, one method may be faster than the other.  In practice, this can surprise you.  Sometimes the statistics and indexes...

Without having sample data, it is tricky to say for certain, but as a thought - would a DISTINCT on your SELECT help?

If not, could you provide some DDL and...

Scott - I am not sure if you saw my most recent reply where I basically retracted my previous statements on NOLOCK.  It was a bit of a ramble and...

I think the first thing I'd ask is - what problem are you trying to solve?

Having an index highly fragmented MAY cause performance issues, or may be perfectly fine.  Are...

Another thought (as I ran into a similar issue when working with Great Pains... I mean Great Plains) - try setting your MAXDOP on that query to 1.  We had...

How are you mapping "REG1" to "SICK1" and REG2 to SICK2?  You would need something to JOIN on.

Using the data you have given, I see no way to map those...

My opinion on the fix - try checking off the other box in the Exchange configuration (use windows authentication) UNLESS you are not using windows authentication for Exchange authentication.  If...

Might be a dumb question, but wouldn't the answer marked as "correct" give you a result different from the expected result?

I say that it might be a dumb question because...

Just to confirm, your query is in the logical format of:

DECLARE @dynSQL NVARCHAR(MAX)
SELECT @dynSQL = 'SELECT 1 AS [result]'

EXEC (@dynSQL)

And you are wanting to insert the results...

I think an article that would be helpful is this one:

https://www.sqlservertutorial.net/sql-server-basics/sql-server-like/#:~:text=The%20SQL%20Server%20LIKE%20is%20a%20logical%20operator,statements%20to%20filter%20rows%20based%20on%20pattern%20matching.

Basically, you are wanting your LIKE syntax to determine if it is numeric OR numeric with a - in it. ...