himanshu.sinha (12/1/2015)

---

I think using a while loop this should be achievable

DECLARE @rng-2 TABLE ( seq int identity(1,1),Id INT, RangeStart BIGINT, RangeEnd BIGINT, Category INT, NumberCount INT)

DECLARE @RNG_output TABLE ( Id INT, Range_No BIGINT, Category INT)

INSERT INTO @rng-2

SELECT 123, 120000006660, 120000006690, 5, 31 UNION ALL

SELECT 123, 120000011660, 120000011670, 5, 11 UNION ALL

SELECT 123, 199000011660, 199000011670, 10, 11 UNION ALL

SELECT 789, 88800001060, 88800001090, 5, 31 UNION ALL

SELECT 789, 99900011660, 99000011675, 10, 16 UNION ALL

SELECT 789, 10000011560, 10000011670, 15, 111 UNION ALL

SELECT 258, 599900010660, 599000010685, 10, 26 UNION ALL

SELECT 258, 510000010560, 510000010565, 10, 6

select * from @rng-2

-- Define variables

Declare @MinValue int

Declare @MaxValue int

Declare @Counter int

Declare @id int

Declare @RangeStart BIGINT

Declare @RangeEnd BIGINT

Declare @Category int

Declare @NumberCount int

Select @MaxValue = max (seq) from @rng-2

Select @counter = 1

--Print 'The max value ' +convert(varchar,@MaxValue )

While ( @counter <= @MaxValue)

Begin

Select

@id = id

,@RangeStart= RangeStart

,@RangeEnd= RangeEnd

,@Category = Category

,@NumberCount = NumberCount

from @rng-2 where seq = @counter

--Print 'The @counter value ' +convert(varchar,@counter )

While (@RangeStart <= @RangeEnd )

Begin

--Print '@RangeStart ' + convert(varchar,@RangeStart)

INSERT INTO @RNG_output (id,Range_No,Category)

SELECT @id ,@RangeStart,@Category

Select @RangeStart = @RangeStart + 1

End

Select @counter = @counter+ 1

-- Resetting the values

Select

@id = 0

,@RangeStart= 0

,@RangeEnd= 0

,@Category = 0

,@NumberCount = 0

End

select * from @RNG_output