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…