Kenneth Fisher plays the FizzBuzz game with T-SQL and his chat piles on:
Now normally FizzBuzz is done with a loop, but as Russ said, we are using T-SQL so batch code is always the goal. That said, what table should I query to get the numbers 1-100? Well, I decided I’d just do something simple here and use a system view that’s more than 100 rows, the ROW_NUMBER function, and restrict it using TOP.
Read on to see several answers to this problem, some better than others.