This was one that surprised me as well. I didn't realize there was that much difference between SET/SELECT.

Thanks, Jeff, and Happy New Year. Hope you're enjoying the day.

Placeholder: https://www.sqlservercentral.com/Forums/1914846/Fantasy-Football-2018

Still looking for emails for 2nd and 3rd place. Let me know where to send a prize.

crazy. Not sure what I was thinking there. Question changed, points awarded back

Are words needed?

Code now attached at the bottom of the article.

Well, I thought I corrected this yesterday. Apparently I must not have saved the changes. Code should be:

SELECT TOP 1
  answer = SomeName
FROM