Hi Dwain,

dwain.c (2/11/2015)

---

You also said originally:

tomek tomek (2/10/2015)

---

as you can see:

1) OrderId=1 was split into 2 rows, as it was partially overlapped by next ranges

2) orderdId 2 and 3 don't...

@mark-3

it seems there's something wrong with your new code (I don't see same problem with previous solution).

for following dataset:

SELECT *

FROM

(VALUES

(1, '1',convert(datetime,'20121001'),convert(datetime,'20141031')),

(2, '7','20140701','20140731'),

(3, '10','20140801','20141031')

) AS...

@mark-3 Cowne - Care to explain, what was wrong with the first approach?

Regards

tomek

Hi,

First of all, thank you all for your input. It is invaluable.

@venoym

your solutions with numbers looks very interesting, but as Dwain suggested I had problems finding out how...

the point is, no one knows the real content (even I, as admin) - until decrypted on a website.

Unfortunately,

i don't have enough knowledge to build my own website conneceted to...

additional question:

The actual situation I have is like this:

StatusType STATUS Object date

---------- ---------- ---------- -----------------------

status1 Closed ...

Hi All,

First of all - Big Thanks for all your input (and good words for newbie as well:).

@Nevyn - thanks for your solution, but as you yourself suggested...

Well....

I kind of have a solution, but it's messy (especially that I acutally have more tables like these to merge, and obviuosly there come joins with other tables).

Maybe someone could...