select *,row_number() over (partition by msisdn,imsi
order by msisdn,imsi desc) rn
into #tt from T_msisdn_imsi_tac_manufacturer_location
select * into #ttt from #tt where rn<12
select *,row_number() over (partition by msisdn,imsi
order by msisdn,imsi desc) rn
into #tt from T_msisdn_imsi_tac_manufacturer_location
select * into #ttt from #tt where rn<12