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,...

All thanks for your time and attention.

I started of with the post:

http://www.sqlservercentral.com/Forums/Topic1760478-3412-1.aspx

And tried to construct a solution from the solution presented there.

That was a bad idea. Spend some time on...

drew.allen (12/20/2016)

---

Most approaches that I've seen collapse the ranges. That is, they don't retain a record with a zero length. Is there a particular reason that you need...

Yes this does help. Thanks.

Although...

GilaMonster (12/1/2016)

---

Keep in mind that the isolation levels affect the behaviour of *read* queries, not data modifications for the most part.

Repeatable read vs read committed: can two identical selects within...

Yes they are WHacked.

Try forcing a loop join reading first from the ranges table like this:

SELECT *

FROM...

Here is a 'fairly' simple solution to your problem.

First a table is 'created' which contains the totals for each column.

Then this table is used to calculate the percentages for all...