-- prepare test data
declare	@test table (Id int, TypeId int, Name varchar(100))

insert	@test
select	1, 1, 'a' union all
select	15, 1, 'e' union all
select	6, 2, 'f' union all
select	3, 1, 'b' union all
select	8, 2, 'j' union all
select	99, 1, 'q' union all
select	10, 2, 'g' union all
select	2, 1, 'd' union all
select	8, 3, 'h' union all
select	17, 1, 'c' union all
select	11, 2, 'u' union all
select	4, 3, 'i'

-- prepare result table
declare	@result table (Id int, Typeid int, Name1 varchar(100), Name2 varchar(100), Name3 varchar(100))

-- do the work
declare	@currenttypeid int,
	@maxtypeid int,
	@n1 varchar(100),
	@n2 varchar(100),
	@n3 varchar(100),
	@loop int

select	@currenttypeid = min(typeid),
	@maxtypeid = max(typeid),
	@loop = 1
from	@test

while @currenttypeid <= @maxtypeid
	begin
		select	@n1 = min(name) from @test where name > isnull(@n3, '') and typeid = @currenttypeid
		select	@n2 = min(name) from @test where name > isnull(@n1, '') and name > isnull(@n3, '') and typeid = @currenttypeid
		select	@n3 = min(name) from @test where name > isnull(@n2, '') and name > isnull(@n1, '') and name > isnull(@n3, '') and typeid = @currenttypeid

		if @n1 is not null
			begin
				select	@loop = @loop + 1

				insert	@result
				select	@loop,
					@currenttypeid,
					@n1,
					@n2,
					@n3
			end

		IF @n3 IS NULL
			SELECT	@currenttypeid = min(typeid)
			from	@test
			where	typeid > @currenttypeid
	end

select * From @result