Interesting T-SQL problems

With this blog post I am hoping to start a new series of blogs devoted to the interesting T-SQL problems I encounter in forums during the week.The idea of this blog series came to me on Wednesday night when I thought I solved a complex problem... First ProblemThe first problem, I'd like to discuss, is found in this MSDN thread:Given this tableSalesDateTime SalesAmount2010-08-10 00:05:12 58.222010