• + 0 comments

    Why did this fail?

    DECLARE @i int = 0, @string varchar(4000) WHILE @i < 1001 BEGIN IF @i = 2 --Two is prime! BEGIN
    SELECT @string = CONVERT(varchar(10),@i) SET @i += 1 CONTINUE END IF((@i % 2) = 0) --If not PRIME, then skip and continue on. BEGIN
    SET @i += 1 CONTINUE END IF @string IS NULL --If first time iterating, don't add &. BEGIN SELECT @string = CONVERT(varchar(10),@i) SET @i += 1 CONTINUE END SELECT @string = @string + '&' + CONVERT(varchar(10),@i) --All other PRIME numbers. SET @i += 1
    END PRINT @string;