4 ms·
--A T-SQL version Select Case When SomeNumber % 3 = 0 and SomeNumber % 5 = 0 Then 'FizzBuzz' When SomeNumber % 3 = 0 Then 'Fizz'
by TedDallas 8y ago
--A T-SQL version
Select Case When SomeNumber % 3 = 0 and SomeNumber % 5 = 0 Then 'FizzBuzz'
When SomeNumber % 3 = 0 Then 'Fizz'
When SomeNumber % 5 = 0 Then 'Buzz'
Else Convert(VarChar(10), SomeNumber)
End As Answer
From (
Select Top 100
SomeNumber = Row_Number() Over (Order By [object_id])
From sys.all_objects
) as Answers