This can also be done with a WHILE statement with the results being put into a table variable. Although I would suggest the other posts first, this is an option.

DECLARE...