bananas, yep makes sense. I didn't even think it was simply an alias.

If all three are zero, desired result would be zero.

SS thanks

Yes 2, sorry

Median and yes 6. I'll search median here, thanks. Found it; I can't remember what I was originally searching by, wasn't median.

http://www.sqlservercentral.com/Forums/Topic1205512-392-1.aspx

perfect, thanks

Thanks!

This was an odd project, since it was a one-time task sql processing performance was not an issue. I should have mentioned that.

I had to add a new reference...

Thanks, your solution makes sense.

Didn't have to deal with gaps. The solutions here solved the issue. I have the list. Thanks to everyone!

I have a reference table that I was given that has 50,000 records. It has ranges between two 11-digit numbers. I need to makes sure there are no...

Jeff:

It was a bad example. The number of combinations between the true numbers is about 50,000 each. I'll try it with 50,000 each on the span and see...

When I use larger numbers I get this error "types don't match between the anchor and the recursive part"

CREATE TABLE #TempBet

(Id int, Low numeric, High numeric)

INSERT INTO #TempBet (Id, Low,...

Reworked another forum solution

DROP TABLE #TempBet

CREATE TABLE #TempBet

(Id int, Low int, High int)

INSERT INTO #TempBet (Id, Low, High)

SELECT 1, 1, 3 UNION ALL

SELECT 2, 2, 3 UNION All

SELECT 3, 5,...

That gets me the first report. Is there a way to dynamically create this report from those results? There would be more time periods and more users.

date ...