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.

            
May 22, 2020 at 4:44 pm
            
#3756886

            
            
                                                
        

To be clear, the link you posted from stack overflow cites TF 4199 and I'm not talking about that.  I'm talking about TF 9481, which fixed my issues when, like...

Awesome.  Thanks for the feedback, Bruin.

+1 Billion to Roger Plowman for his post above.  I'll also add that commenting code when you're writing it is pretty simple.  The first thing I normally do...

...The first thing I normally do is to write the comments of the things I need to get done and why.  That also creates a bit of...