Heh... you spelled it incorrectly, David... it's not "shiny".  Replace the "n" to get the true meaning. 😀

Might have even been a "Line#" column so you could verify that no lines were lost during transmission and to also guarantee a sort order if that was important to...

Just as a side bar, I generally don't mix meta data (headers/footers/line counts, whatever) in fixed field format files simply because most people on the receiving end have problems dealing...

I agree with Phil.  Headings longer than the column width of a fixed field format file just aren't going to work.  For such files, folks usually don't include a header...

While I agree that "Perfection can be the worst enemy of good", I've found that "Change is the worst enemy yet".  I have found that way too many people change...

On that note, Paul White wrote some great articles on both.  You can find them below...

https://www.sqlservercentral.com/articles/understanding-and-using-apply-part-1

https://www.sqlservercentral.com/articles/understanding-and-using-apply-part-2

Good Sir... thank you for taking it the right way.  A lot of people would have taken it all offensively.  You DO have the right stuff, Michael.

I can't speak for what others know of the subject but we always disable the browser service to enhance security.

Heh... not enough coffee... when I first read the title of this article, I thought it said "The Wife List", which is a huge part of "The Life List".

Doing things at the database level isn't necessarily doing the same as doing something at the server level.  I strongly recommend that you try TF 9481 at the server level...

Again... teaching a man to fish. 😀

If you do a search for "subqueries in sql server" and look for the "Microsoft Docs" (BOL) entry in the returns, you'll end up...

I am testing the TRY_CONVERT( ).  Here is my code:

SELECT TRY_CONVERT(int, 'ABC') as Result;-- returns a NULL

SELECT TRY_CONVERT (XML, 10) as Result;-- results in an error

The...

Hello,

I have an issue with 2 users who have access to all the db's but two of those db's they get an error when accessing objects

i have doubled check...

Here's some code... it obviously won't run the way it is but it will give you an idea of how to do this and make your DBA happy.

--Jeff Moden 
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.

First step towards the paradigm shift of writing Set Based code:

________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:

How to post code problems

How to Post Performance Problems

Create a Tally Function (fnTally)