Yep... I agree... sorry I missed that...

Nice job again. Looking for work?

Nah... Scott would think I'm looking for a cure for cancer

You mean this query???

Declare @Counter int

Set @Counter = 1

While @Counter <= 1000000

  Begin

     Print Case When @Counter % 15 = 0 Then 'BizzBuzz'

           When...

Heh... relax, Scott... we're all having a bit of fun here.  Grant's post was great for stirring the pot... haven't seen this much going on in a long time.  It's...

Very cool... thanks Omri.

Andrew... this is what I'm referring to as "summary tables" and others refer to as "Star Schema" or "OLAP"...

http://www.ciobriefings.com/whitepapers/StarSchema.asp

Why are you hard coding the nubmer 2?  Also, What is the "slno" column?  If it's the sequential column that everyone has been listing, that column is there just so...

Heh... I agree... what you described those folks did sounds absolutely insane even for concentrated "performance improvement" efforts.  Sounds like someone spent a whole lot of time on the wrong...

I didn't completely dismiss WHILE loops... take a look at the end of my first post.

And of course no one would spend as much time during an interview as we have...

Goto???

We can only guess unless you provide the formula in the query and some sample data.

Here's my guess... you have something in the CHAR column that doesn't translate to a...

I think I've found one of the articles that started this whole BizzBuzz line of questioning at...

http://tickletux.wordpress.com/2007/01/24/using-fizzbuzz-to-find-developers-who-grok-coding/

In that article, the author summarizes with the following... my responses are in...

And, you left out a THEN necessary to make it work   And, although you think B will save half of the modular calculation,...

Heh... looking at it the wrong way...

Original budget/deadline was wrong because you didn't bid right... Client necessarily changes scale... wants to know why idiots wrote code that wasn't scalable... all...