sql query not giving expected results in sql server

Question

I am using sql server and this is my table structure

start end interval
1     3   1
9     12  1
16    20  2
100   120 5

expected result

i tried this before posting here

select start as result,end1,interval
from table
union
select result+1,interval,end1,interval 
from table

What is the logic you were trying to write? How is the expected result is calculated? — Sateesh Pagolu
– Sateesh Pagolu, Commented Mar 6, 2014 at 14:14

Michael Bowersox · Accepted Answer · 2014-03-06 14:21:34Z

2

This is a perfect place to use a CTE. The following code should give you the answer you're looking for:

;WITH IntervalCTE AS
(
  SELECT [start] AS Value, [end], [interval]
  FROM T
  UNION ALL
  SELECT [Value] + [interval], [end], [interval]
  FROM IntervalCTE
  WHERE [Value] < [end]
)
SELECT Value FROM IntervalCTE ORDER BY Value

I've also created a SQL Fiddle that you can look at.

answered Mar 6, 2014 at 14:21

Michael Bowersox

1,48111 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql query not giving expected results in sql server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related