I had the requirement to put on auditing. I made the server specifications, put in a file, and read the file info a database only the security officer can...

Which columns are used to determine if a row is a duplicate or not?  I'm not talking about after you use ROW_NUMBER() to mark them... I'm talking about what did...

Sounds like an excellent plan.

Lowell.   THANK YOU.   I was overthinking it.  Why didn't I think of your first one for the NOT IN.  But thanks for the second one as well. ...

I'm shocked!! A...

A cursory glance says it looks fine.  I didn't do a deep dive on it.

Heh... I got it right but I suck at taking tests even if they're just one question long.  I knew the answer without looking at the list of answers but,...

GOOD MORNING GRANT!!!!

I recently saw an article about "Self-made men" and it expresses exactly the way I feel.  To summarize, I'm definitely not "self-made".  I'm where I'm at because of...

Yea, that is the problem with this one.  It only lists the dbs since last server restart that have been accessed, I want an opposite list.  In a SQL...

Agreed. ...

Glad to have been able to help.  Thank you for the feedback.

Here you go.  DelimitedSplit8K made the changes very simple.

--****** This is for when the position matches, as well... ******
--===== Define what we're looking for.
   ...

I changed the order by and it returned 12 records for the 1st month. I'm expecting 5 records for each month. Thank you.

SELECT DISTINCT t.Company,sales.[Month], sales.Sales
FROM...

Heh... serendipity strikes.  There's a pretty good article on all of this that was in an article in yesterday's MSSQLTips email.  The link to the article I'm talking about is...

My apologies... I missed the part about the "array position" in your original post.  We can fix that but Split_String isn't going to work at all for that because (and...