asked on

Program Logic to summaries Data

I have a stored Procedure which returns me route Information to build a route table. The return data looks like the sample below

I have a app which queries a MS Sql Table which returns me Phone nbr Prefixes,Start and End Nbrs
The field is called prefix ,start,end and has data like

Prefix Trunk
===================
213232 Trunk 1
213235 Trunk 1
213238 Trunk 1
213239 Trunk 1
213242 Trunk 2
213243 Trunk 1
213446 Trunk 1

to save space in my other apps i need to be able to get to be able to find all continues blocks and then summaries them like this

Start+ End Start End Trunk
213232_239 213232 213239 Trunk 1
213242 213242 213242 Trunk 2
213243_446 213446 213446 Trunk 1

ASKER CERTIFIED SOLUTION

amyhxu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

AlexPonnath

ASKER

yje first one is a Table in SQl Server, the second one is the output i like to save to a Text file
based on the Query and the logic..

AlexPonnath

ASKER

Also i would like not to use a dataset if posible but rather use a data reader