Collapsing Data

I want to collapse the incoming data based on the Plus4 High and low values. Here is the format





Code Block

create table #rangetbl (zip varchar(5), zipl varchar(4), ziph varchar(4), zipid varchar(4))

insert into #rangetbl values('90112','0000','0100','SET1')
insert into #rangetbl values('90112','0101','0210','SET1')
insert into #rangetbl values('90112','0211','0320','SET1')
insert into #rangetbl values('90112','0400','0500','SET2')
insert into #rangetbl values('90112','0503','0600','SET2')

Expected Output

ZIP low high identifier
90112 0000 0320 SET1
90112 0400 0500 SET2
90112 0503 0600 SET2


In this case a "set" is when the values immediately follows the high values. 0101 is the next number to 0100, 0211 is after 0210 so on and so forth and they all belong to the same set. If the sets are different we should not collapse the data.

Current code uses cursors to do the collapsing of data I was wondering if a TSQL can do the job.

Thanks