DECLARE @t table ( t1 Int,
t2 int,
t3 int )

insert into @t (t1,t2, t3)
values (1,1,5)
insert into @t (t1,t2, t3)
values (1,1,2)
insert into @t (t1,t2, t3)
values (1,1,3)
insert into @t (t1,t2, t3)
values (1,2,5)
insert into @t (t1,t2, t3)
values (1,2,2)
insert into @t (t1,t2, t3)
values (1,2,3)
insert into @t (t1,t2, t3)
values (1,3,5)
insert into @t (t1,t2, t3)
values (1,3,2)
insert into @t (t1,t2, t3)
values (1,3,1)

Declare @k table
( t1 Int,
t2 int )
insert into @K (t1,t2)
SELECT M.t1,M.t2 FROM @t M group by M.t1, M.t2

SELECT * FROM @t

DECLARE @S table ( t1 Int,
t2 int,
t3 int )

DECLARE @v1 int, @v2 int

set @v1=0
set @v2=0

select top 1 @v1=t1, @v2=t2 from @k where ((t1=@v1)and (t2> @v2) )OR (t1>@v1) order by t1,t2
while @@rowcount >0
begin
insert into @S (t1,t2, t3)
SELECT TOP 1 t1,t2, t3 FROM @t WHERE ( t1=@v1) and ( t2=@v2) order by t1,t2

select top 1 @v1=t1, @v2=t2 from @k where ((t1=@v1)and (t2> @v2) )OR (t1>@v1) order by t1,t2
end
SELECT * FROM @s
go