While Loop Gives Records One By One

Hi,





I have this stored procedure:





ALTER PROCEDURE dbo.spTest





AS





declare @idQuestion int


set @idQuestion = 0





while @idQuestion <= 5





BEGIN


set @idQuestion = @idQuestion + 1


SELECT @idQuestion


END





RETURN





and it returns values in this format:





-----------


1





-----------


2





-----------


3





What do I have to change so the results are something like my next example so I can extract them with a data reader





-----------


1


2


3





I would like to use the while loop as this example is a simplified version of my stored procedure.





Thank you,





dg