What I've replied with is a traditional loop not cursor at all.

Check this article

[/url]

set @count = 0

select quantity from .....

while @count < quantity

begin

set @count = @count + 1

insert .......

end