I checked out Grant Fritchey's[/url] article and was, like Jeff, not very pleased to see some while loops but one query attracted my attention and I tested it and I like it.

;WITH Nbrs(n) AS

(

SELECT 1

UNION ALL SELECT 1 + n FROM Nbrs WHERE n < 100

)

SELECT CASE WHEN n%5=0 AND n%3=0 THEN 'BizzBuzz'

WHEN n%3 = 0 THEN 'Bizz'

WHEN n%5 = 0 THEN 'Buzz'

ELSE CAST(n AS VARCHAR(8))

END

FROM Nbrs

OPTION (MAXRECURSION 100);