Why do you think it is clunky?

I cringe...

No. Did not know it was a kids game. Interesting insight.

Which sparks a question - why is it called FIZZBUZZ?

Is it because you get a Buzz from the Fizz of a Cola?

Comeback (as in NBA action yesterday)

Sean-752587 (2/22/2010)

---

Jason

As far as scaleability is concerned, I did try it with 1 Mil. rows which didn't work in my master database (SQL 2008 dev edition). It topped out at...

Thanks for the article. I tend to use the method similar to what Paul described.

Yes - that is a classic. I used to have it hanging in my office. Then I moved.

jcrawf02 (2/22/2010)

---

Agree with Gus on the self-documentation, makes it clearer WHY you're doing it. Comments could do that too, suppose.

Sean, on yours, casting is unneccessary until the ELSE, and makes...

GSquared (2/22/2010)

---

Just to annoy Jeff, here's my "ultimate version":

SET NOCOUNT ON;

DECLARE @Table1 TABLE (

ID int IDENTITY PRIMARY KEY,

Number int);

DECLARE @Number INT;

SELECT @Number = 1;

WHILE @Number <= 100

BEGIN

INSERT INTO @Table1 (Number)

SELECT...

J.Faehrmann (2/22/2010)

---

I strongly favour the loopbased solution for this limited task. It is concise, readable without any comments and done quickly.

It performs well enough.

DECLARE @i INT

SET @i = 1

WHILE...

Another option would be check out this puzzle roundup[/url] by Grant Fritchey.

Jeff Moden (2/21/2010)

---

Heh... I just Googled "FIZZBUZZ SOLUTIONS SQL"... I'm amazed and surprised that some of those folks had the nerve to publish some of the solutions they have. ...

These sorts of questions could be good. They could also lead down the slippery slope. If speed over quality is the most important - you will end up...

RBarryYoung (2/21/2010)

---

CirquedeSQLeil (2/21/2010)

---

Actually creating a thread or forum is not the difficult thing by far.

The difficult thing is ensuring that people read it. Just like a Terms & Conditions...

Check the article by Gail Shaw in my...