declare @c varchar(413),@i int;select @c='',@i=1
while @i<101
select @c=@c+case @i%3 when 0 then case @i%5 when 0 then 'FizzBuzz' else 'Fizz' end else case @i%5 when 0 then 'Buzz' else ltrim(@i) end end+char(10),@i=@i+1
select @c

declare @p int set @p=1while @p<101begin print ISNULL(NULLIF(CASE WHEN @p%3=0THEN'Fizz'ELSE''END+CASE WHEN @p%5=0THEN'Buzz'ELSE''END,''),@p)set @p=@p+1 end

declare @ int
set @ = 3
select @

create table [ ] (i int)
go
select * from [ ]
go
drop table [ ]

quote:

---

An example of a Fizz-Buzz question is the following:

Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are multiples of both three and five print “FizzBuzz”.

Most good programmers should be able to write out on paper a program which does this in a under a couple of minutes.

Want to know something scary ? - the majority of comp sci graduates can’t. I’ve also seen self-proclaimed senior programmers take more than 10-15 minutes to write a solution.

I’m not saying these people can’t write good code, but to do so they’ll take a lot longer to ship it. And in a business environment that’s exactly what you don’t want.

This sort of question won’t identify great programmers, but it will identify the weak ones. And that’s definitely a step in the right direction.

---

using System;
using System.Collections.Generic;
using System.Text;

namespace FizzBuzz
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Beginning app...");

            for(int i = 1; i<=100; i++)
            {
                if (((i % 3)==0) && ((i % 5)==0))
                
                    Console.WriteLine("FizzBuzz!");
           
                else if ((i % 3)==0)
                
                    Console.WriteLine("Fizz");
                
                else if ((i % 5)==0)
          
                    Console.WriteLine("Buzz");
                
                else
                    Console.WriteLine(i);
            }
            Console.ReadKey();
        }
    }
}

quote:

---

Originally posted by jsmith8858

that is hilarious, I had no idea that was legal...

declare @ int
set @ = 3
select @

who would have thunk it ..... I guess it is kind of like creating a table name with only spaces, which is legal as well....

create table [ ] (i int)
go
select * from [ ]
go
drop table [ ]

Think of the database we could design using these tricks !!!! Completely unmaintainable !

- Jeff
http://weblogs.sqlteam.com/JeffS

---

quote:

---

Originally posted by jsmith8858

From the link:

FizzBuzz was presented as the lowest level of comprehension required to illustrate adequacy. There's no glory to be had in writing code that establishes a minimum level of competency. Even if you can write it in five different languages or in under 50 bytes of code.

The whole point of the original article was to think about why we have to ask people to write FizzBuzz. The mechanical part of writing and solving FizzBuzz, however cleverly, is irrelevant. Any programmer who cares enough to read programming blogs is already far beyond such a simple problem. FizzBuzz isn't meant for us. It's the ones we can't reach-- the programmers who don't read anything-- that we're forced to give the FizzBuzz test to.



- Jeff
http://weblogs.sqlteam.com/JeffS

---

Slightly shorter:
declare @ char(3)set @=0while @<100begin set @=@+1print case when @%15=0then'FizzBuzz'when @%3=0then'Fizz'when @%5=0then'Buzz'else @ end end

Than this:
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

SELECT case when (Num1 + Num2) % 15 = 0 then 'FizzBuzz'
	when (Num1 + Num2) % 3 = 0 then 'Fizz'
	when (Num1 + Num2) % 5 = 0 then 'Buzz'
	else cast(Num1 + Num2 as varchar(10)) end AS SQLFizzBuzz
FROM (
	SELECT 1 Num1 UNION ALL
	SELECT 2 UNION ALL
	SELECT 3 UNION ALL
	SELECT 4 UNION ALL
	SELECT 5 UNION ALL
	SELECT 6 UNION ALL
	SELECT 7 UNION ALL
	SELECT 8 UNION ALL
	SELECT 9 UNION ALL
	SELECT 10
	) AS S1
CROSS JOIN (
	SELECT 0 Num2 UNION ALL
	SELECT 10 UNION ALL
	SELECT 20 UNION ALL
	SELECT 30 UNION ALL
	SELECT 40 UNION ALL
	SELECT 50 UNION ALL
	SELECT 60 UNION ALL
	SELECT 70 UNION ALL
	SELECT 80 UNION ALL
	SELECT 90
	) AS S2
ORDER BY Num1 + Num2

quote:

---

Originally posted by jsmith8858

This is definitely silly. but I'll bite. here's one without a CASE that's 135 characters ....

declare @ int set @=0while @<100begin set @=@+1 print left(@,sign(@%3*@%5)*3)+left('fizz',4-sign(@%3)*4)+left('buzz',4-sign(@%5)*4)end

- Jeff
http://weblogs.sqlteam.com/JeffS

---

quote:

---

Originally posted by snSQL

Of course, we should really not be writing T-SQL for this that uses variables and loops and print statements. With no attempt to keep it short:

SELECT case when (Num1 + Num2) % 15 = 0 then 'FizzBuzz'
	when (Num1 + Num2) % 3 = 0 then 'Fizz'
	when (Num1 + Num2) % 5 = 0 then 'Buzz'
	else cast(Num1 + Num2 as varchar(10)) end AS SQLFizzBuzz
FROM (
	SELECT 1 Num1 UNION ALL
	SELECT 2 UNION ALL
	SELECT 3 UNION ALL
	SELECT 4 UNION ALL
	SELECT 5 UNION ALL
	SELECT 6 UNION ALL
	SELECT 7 UNION ALL
	SELECT 8 UNION ALL
	SELECT 9 UNION ALL
	SELECT 10
	) AS S1
CROSS JOIN (
	SELECT 0 Num2 UNION ALL
	SELECT 10 UNION ALL
	SELECT 20 UNION ALL
	SELECT 30 UNION ALL
	SELECT 40 UNION ALL
	SELECT 50 UNION ALL
	SELECT 60 UNION ALL
	SELECT 70 UNION ALL
	SELECT 80 UNION ALL
	SELECT 90
	) AS S2
ORDER BY Num1 + Num2

---

select
	case
	when 	number % 15 = 0	then 'FizzBuzz'
	when 	number % 3 = 0	then 'Fizz'
	when	number % 5 = 0	then 'Buzz'
	else	left(number,3)
	end	SQLFizzBuzz
from
	F_TABLE_NUMBER_RANGE(1,100)