funk.phenomena Yak Posting Veteran
Canada 98 Posts
USER_ID QTY jsmith 2 rbird 4 lsantore 1
USER_ID jsmith jsmith rbird rbird rbird rbird lsantore
Lamprey Flowing Fount of Yak Knowledge
3856 Posts
DECLARE @Foo TABLE (USER_ID VARCHAR(128), QTY INT) INSERT @Foo VALUES ('jsmith', 2), ('rbird', 4), ('lsantore', 1) SELECT T.USER_ID FROM @Foo AS T INNER JOIN master..spt_values AS A ON A.number <= T.Qty aND A.Type = 'P'
Simple LOOP
Posted - 09/25/2012 : 17:07:11
