+1

Unless of course you allow duplicates in your table, like the last row in the following:

INSERT INTO #Temp

Select 1, 1, 'First' UNION ALL

Select 1, 2, 'Second' UNION ALL

Select 1, 3, 'Third' UNION ALL

Select 1, 4, 'Fourth' UNION ALL

Select 1, 5, 'Fifth' UNION ALL

Select 1, 6, 'Sixth' UNION ALL

Select 1, 7, 'Seventh' UNION ALL

Select 1, 8, 'Eighth' UNION ALL

Select 1, 9, 'Ninth' UNION ALL

Select 1, 10, 'Tenth' UNION ALL

Select 2, 3, 'Third' UNION ALL

Select 2, 4, 'Fourth' UNION ALL

Select 2, 5, 'Fifth' UNION ALL

Select 2, 6, 'Sixth' UNION ALL

Select 2, 7, 'Seventh' UNION ALL

Select 2, 8, 'Eighth' UNION ALL

Select 2, 9, 'Ninth' UNION ALL

Select 3, 1, 'First' UNION ALL

Select 3, 2, 'Second' UNION ALL

Select 3, 3, 'Third' UNION ALL

Select 3, 4, 'Fourth' UNION ALL

Select 3, 5, 'Fifth' UNION ALL

Select 3, 6, 'Sixth' UNION ALL

Select 3, 7, 'Seventh' UNION ALL

Select 3, 8, 'Eighth' UNION ALL

Select 3, 8, 'Eighth';

I believe what Luis has done could be modified for this case, but I'll leave that to you if you say it can happen.