Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Grant Fritchey The T-SQL Quiz RE: The T-SQL Quiz
SwePeso
SSC-Dedicated
Points: 39752
More actions
May 28, 2007 at 5:48 am
#709181
declare @ int set @=1while @<101begin print ISNULL(NULLIF(CASE WHEN @%3=0THEN'Fizz'ELSE''END+CASE WHEN @%5=0THEN'Buzz'ELSE''END,''),@)set @=@+1 end
N 56°04'39.16"E 12°55'05.25"