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...

Heh... you read into it, ol' friend... no where in the post does there say anything about a time limit. 

[Edit] Ok, I see...

(This is going to sound like a bit of a rant... and it probably is.   Sorry... )

Although Grant mentioned it in the end,...

Heh... if you posted some data, it wouldn't have been helpful... it would have been done.

I know you're a newbie here but ya gotta trust me on this... if you...

From everything I could find, you just add it back in as you would any other... the caveat may be that it might be case sensistive.  It would also need...

Heh... I'm thinking that those types of questions should be posed and answered BEFORE such action is taken.

I'm a bit confused by your...

Like anything else, "It Depends".  What is the table being used for?  Does it have a clustered PK or clustered index?  Is anything "time sensitive" in the table?  How frequently...