OK, so it's a cute CTE exercise.

But has anyone ever used the Fibonacci series values for anything in the real world?

I would be curious to know.

robertm-772679 (9/18/2014)

---

Well written. I like number 9 especially. I can't tell you how many times I've said that no matter how much I test a new piece of code it...

Ah yes, completely missed that 5a.

So 10.5 means ten and half commandments.

So 5a is half a commandment.

I guess, once you reach 11 you can't pretend to have 10 any more.

Thus...

Maybe I didn't explain myself.

In the title above, what is the meaning of...

And the meaning?

But you skipped 10.5!

Forgive my ignorance, but I can't quite grasp the (.5) in 10 (.5)?

I tried to lay back and relax and read that thing.

I tried to lay my head down to...

Yes it's a lot faster. Thus on half a million rows

3243 milliseconds using my scalar function

3822 milliseconds using scalar function which applies your min/max concept (thus slightly less code)

593 milliseconds...

Show me an example given a table with 4 dates.

It should return the 4 dates and the result.

Have never used this ITVF technique.

Very neat idea this Max(From), Min(To).

But when I try this on a scalar function it runs slower than my scalar function.

Don't know why, but I don't use table valued function...

Have a go at this:

create function overlaphours(@s1 as datetime,@f1 as datetime,@s2 as datetime,@f2 as datetime) returns integer as

begin

declare @result as int

set @result=0

if @s2>=@s1 and @f2<=@f1

set @result=datediff(hh,@s2,@f2)

else if @s2<@s1...

This corruption issue has always intrigued me.

I have always wondered whether anyone has done any investigation on an actually corrupt database to see where it has become corrupt and possibily...

zafarthesultan (6/2/2014)

---

The problem with my data is it comes as a result of a lot of calculation in a stored procedure. In the end there is only one temporary table...

I woulld be very curious to know from the OP what kind of environment produces this sort of data.

Although the problem is interesting, what exactly does the query result tell...

Eirikur,

I recently re-ran into this old problem of not being able to drop/create the same temporary table more than once in a stored procedure.

At this discussion forum

http://stackoverflow.com/questions/9812302/can-i-recreate-a-temp-table-after-dropping-it

it states at the...