From Books Online, search "FOR LOOP":

DECLARE
@COUNTER NUMERIC
SELECT @COUNTER = 1
WHILE (@COUNTER <5)
BEGIN
    SELECT @COUNTER = @COUNTER +1
END

I've never done it, but, like I said, this example is from Books Online.

>Anyone knows if it's possible to make a cycle in SQL "language"?