Ok... so basically when you ask it to opperate a command on a column, then, it will identify the command, then enact it on every row instead of asking for...

I didnt know SQL could do that.

And you made me a believer, a very confused one, but still believing.

So now I'm really curious, WHY does the set loop work fasther?...

The set was much faster.

However, I must note that in order for the set to work, you must have the pre-existing data for it to compute, which whould require either...

Of the solutions printed in the article, his had the fastest computing time.

Please excuse my ignorance, but what is wrong with while loops?

Chris had the most elegant solution, all he had to do was rearrange the order of his if statements, ie...

declare @i int

set @i = 1

while( @i < 101)

begin

if @i%3...