Sql return duplicate copies of a row based on a value in a column that row

This Row:

ID DESC QUANTITY

1 ITEM 3

Is it possible form a query to give me a result such as:

1 ITEM
1 ITEM
1 ITEM

select t.id,t.desc from yourtable t
inner join master.dbo.spt_values v
on v.type = 'p' and v.number<t.qty

Kaynak: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106029