Can you post the table sizes ?

I do not understand the construction around Table_G.
This looks 'nondeterministic' which could cause problems. The number of different results that this subquery...

All thanks for your effords.

But for a number of purposes I do prefer the information_schema. Especially when advising to college's.
It is less comprehensive and therefore easier to...

Oops, my bad, I want an 8 bit character set and not a 2...

Sorry,...

--============================================================================

-- The actual solution... (Based on the solution given by Jason A. Long, thanx).

-- Adapted to the example.

-- Corrected for : 1 Enddate does not change.

--...

Jason A. Long (12/22/2016)

---

This should be a simpler & faster solution as it only takes a single pass over the data...

-- Setup some test data...

IF OBJECT_ID('tempdb..#TestData', 'U') IS NOT NULL...

Exactly what was asked, thank you.

I am...

Sergiy (12/22/2016)

---

The testtable definition was in the post before my previous post.

At the start of that code the text is : -- ...

Sergiy (12/20/2016)

---

Here is something to start with:

SELECT ID, FromValue, ToValue

INTO #Periods

FROM (

SELECT 1, 2.1, 8.0

UNION

SELECT 2, 3., 4.5

UNION

SELECT 3, 4., 10.

UNION

SELECT 4, 9., 20.

) I (ID, FromValue,...