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

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