Your requirements are very ambiguous.
"a value from a column for a date and another value from another column for another date"

This is vague and a reason why...

Apparently I can't count.

It's certainly the year of  1 step forward, 1 back for me. I guess I'll finish around 7-6

I wonder if this will grow. Like most of you, I think this is limited to a few narrow niche areas, but I also could see this as more than...

Also, thanks for the update. Hope it keeps working for you.

That's interesting. I guess if you're a user in the db context and set single user with rollback, the other users are disconnected and then you have the only connection....

FORMAT() is slower than CAST/CONVERT, but has some advantages in handling different regions and more flexibility. I like it, but I'd use it judiciously.

Wow, 7th place for me, but 4 of us are 4-3.

I'm sure you'll learn something. Whether you use it or not, or it makes sense in your situation, is another story.

Thanks, that upper case part is good to know. Glad NETBIOS is still working as smooth as ever.

1,2,3 was a typo. It should have been 1, 1, 2 for all answers to make things consistent. Points awarded back.

New web server should be online.