Piotr > I need to get list of number (f.e 1,2,3,4,5) as rows but using only SQL query > (without extra table or view). > > Something what after running query looks like: > > List_of_numbers > > ----------------------- > > 1 > 2 > 3 > 4 > 5 > > Any ideas?? >
EXECUTE BLOCK (
StartNumber Integer,
EndNumber Integer
) RETURNS (
List_of_Numbers Integer
) AS
BEGIN
List_of_Numbers = StartNumber;
WHILE (List_Of_Numbers <= EndNumber) DO BEGIN
Suspend;
List_Of_Numbers = List_Of_Numbers + 1;
END
END
