I would say using 0 to represent 01-01-1900 or -1 to mean 12-31-1899 is far more 'tricky' of code than coding a loop.  Coding a loop is (has been for...

In a follow up post KGJ-dev wanted to be able to pass any number of months.  That's why I tried each for more than 24.

In my testing:
ChrisM's...

This may be 'the long way around the barn', but it works.  You could set this up a a SP and pass it the number of months you want and...

I've been using OneNote, I created a section to hold all of these scripts.  Each script is on a separate page within the section, I try to give each page...

You should be able to use the MAX to get what you want, unless I'm not understanding your issue.

DECLARE @sample TABLE
(
    ContactID INT,
    RenewalDate...

OMG, the game of my life.  The first 6 shots I had I sank the sub and destroyer.  Took 8 more shots to get the Aircraft carrier, then 7 more...

This is what i have for converting to a Julian date, also included is converting a Julian date back to a regular date.

DECLARE @input_date DATETIME;

"The leadership of PASS regularly changes, and we see that again this year with three new board members starting this January. I'd like to welcome John Martin, Diego Nogare, and Chris...