FizzBuzz answer using T-SQL

gistfile1.sql

SELECT CASE
	WHEN number % 3 = 0 AND number % 5 = 0 THEN 'FizzBuzz'
	WHEN number % 3 = 0 THEN 'Fizz'
	WHEN number % 5 = 0 THEN 'Buzz'
	ELSE CONVERT(VARCHAR,number)
	END AS FizzBuzz
FROM master.dbo.spt_values
WHERE number BETWEEN 1 AND 100
	AND type='P'