[thelist] math help...

[Brian Cummiskey]

Joshua Olson wrote:

> Assuming that the random is truly random, you should have (26 + 10)^5
> permutations, or 60466176.

Thanks Josh.

Time to tear apart this stored procedure...  looks like it's all taking 
place here:


if exists(
	select confirmation_code
	from TABLE
	where confirmation_code=@confirmation_code
	)
	---the confirmation code has been used
		begin
			goto repeat
			-- re-does the whole random process
		end
else
	---get the cconfirmation code successfully
		begin
			insert TABLE (confirmation_code)
			values (@confirmation_code)
		end



Looks right to me :(
Anyone see anything?