Thom A, I could imagine your suggestion might result in better performance if large offsets are added (or subtracted) from a date. However the function was designed for an...

Thanks for your suggestions and sorry about delay of reply - have been out of office for a couple of days/ Unfortunately, as good as they are, the suggestions...

I was pretty sure that was true but you...

Heh... I found my pre-migration avatar on this site.  It's not that it didn't "come" over.  It's that it's an animated .GIF and the avatar on this site...

What I'd like to know is how to enable the functionality of the SQLCMD mode (not the other SQLCmd as in .exe) functionality in a stored procedure.

Is there a script that scan take text that is not column delimited and transfer each line into a separate record and each line where it is separated by...

If I'm reading your post correctly, I actually DO demonstrate that phenomena in the article in a couple of places.

Quoting is a big challenge with styling and code. Really, I'd urge you to avoid hitting quote every single time. In this thread, it is often helpful, but in...

Ah... sorry, Jonathan... If that came across as me badmouthing your code, it wasn't what was intended, especially since the OP provided no data to suggest that a daily boundary...

Lordy......

• This reply was modified 7 years ago by Jeff Moden.

Please ignore this post.  It's just a test to see if I was able to clear up a problem where SSC thought I was trying to post empty replies.

Unless I'm misreading the given solution, it won't properly calculate the time difference correctly for entries that span a date boundary.

This is one of the many reasons why I rail...

Have a look at the following link... pay particular attention to the Light Blue box of text in it...

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-ansi-nulls-transact-sql?view=sql-server-2017

A whole lot of front-end Developers in the world wrote code...

Quite a few people use Ola Hallengrens solution for this, if you google that name it will come right up.. just schedule the job to run during your maintenance...

If you don't have mirroring or log shipping or anything else running that would be damaged by changing the Recovery Model, do a log backup, change the recovery model to...