Interesting T-SQL problems

When I wrote my first article with the same name here, Interesting T-SQL problems, I was thinking it will be a weekly series. However, as it often happens, not all intentions become a reality.So, about a month and a half later, I want to discuss a few problems I encountered in different forums during the time since the last blog, that somehow caught my attention. The first problem is found here (