or maybe something like that?
declare @temp table (Record int, Type varchar(1), Number int)
insert into @temp values (1,'B',100)
insert into @temp values (2,'B',106)
insert into @temp values (3,'R',102)
insert into @temp values (4,'S',105)
insert into @temp values (5,'R',104)
insert into @temp...