I thought this was fun. I keep stopping to think about how it works, so good reminder for me as well.

It was a good ride, but ended with Ben getting hurt and his replacement sending all the points to the Schuster kid. Oh well, a fun season.

Still not sure where to use this, but it is an interesting function. Glad you all enjoyed it.

I text my hotel room number and parking spaces to myself. Sometimes I forget where things are on different trips.

I'm not sure what this function is useful for, but I'm sure someone found a use. The best use so far is splitting IP addresses.

Quite the game last night for Henry. Watching him push people around was fun. Otherwise, not much of a contest.

cheers

head() gives you data, but not types.

Please don't post a question here. If there isn't a forum, pick a forum that's close and start a new thread. Don't hijack others.

I've added an ADF forum...

Calendar Table - http://www.sqlservercentral.com/articles/calendar/145206/
That will help you get this done. Depending on your locale, this might need modifications.

What version of SQL Server are you using?