Dixie,

I've no interest in competing, at all, which is all you seem interested in. That was not the spirit of my initial post. Have a good one.

One last note, the...

Hey Dixie,

Sorry you misunderstood, the point was actually the holiday aspect, rather than the calendar table itself. The article itself is years old at this point, I've not much interest...

Hey, Check out the article I wrote for technet about the same thing.

It comprises some functions to help calculate holidays.

http://social.technet.microsoft.com/wiki/contents/articles/29260.sql-developers-toolbox-calendar-tables-explained.aspx

There's a sneaky trick I like to use in this scenario that can shorten the code, and I feel make it more readable.

'PO' = SUBSTRING(CustomerNotes, CHARINDEX('PO:', CustomerNotes)+3, COALESCE(NULLIF(CHARINDEX(' ', CustomerNotes,...