Bank Row Groupings, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

create table Bulk_Table (LineNumber int, [Data] nvarchar(max))
insert into Bulk_Table
VALUES
(1,'100000 BANK       RUNNER222----BANK FILE                  PAGE 1')
,(2,'OTHER RELATED DATA----------------------------------')
,(3,'OTHER RELATED DATA----------------------------------')
,(4,'OTHER RELATED DATA----------------------------------')
,(5,'100000 BANK       RUNNER222----BANK FILE                  PAGE 2')
,(6,'OTHER RELATED DATA----------------------------------')
,(7,'OTHER RELATED DATA----------------------------------')
,(8,'OTHER RELATED DATA----------------------------------')
,(9,'OTHER RELATED DATA----------------------------------')
,(10,'100000 BANK       RUNNER222----BANK FILE                  PAGE 3')
,(11,'OTHER RELATED DATA----------------------------------')
,(12,'OTHER RELATED DATA----------------------------------')
,(13,'OTHER RELATED DATA----------------------------------')
,(14,'OTHER RELATED DATA----------------------------------')
,(15,'TOTAL                                         100.00 ')
,(16,'111111 BANK       RUNNER222----BANK FILE                  PAGE 1')
,(17,'OTHER RELATED DATA----------------------------------')
,(18,'OTHER RELATED DATA----------------------------------')
,(19,'OTHER RELATED DATA----------------------------------')
,(20,'OTHER RELATED DATA----------------------------------')
,(21,'111111 BANK       RUNNER222----BANK FILE                  PAGE 2');
    
    
create table MyTempTable(
    [Start] int,
    [End] int,
    [Data] nvarchar(max)
)

insert into MyTempTable([Start], [End], [Data])
select 
    min(LineNumber),
    max(LineNumber),
    left([Data], 11) as FirstElevenCharactersOfData
from Bulk_Table 
where [Data] like '%RUNNER222----BANK FILE%'
group by left([Data], 11)

select * from MyTempTable

View schema
Execution time: 0,02 sec, rows selected: 2, rows affected: 23, absolute service time: 0,17 sec