OK thanks, let me give that a try. Much appreciated !

Greg

Well that's 14 views and no responses. I knew this would be tricky...

Thanks, I sorted it out myself - sorry to waste your time.

Regards, Greg.

Yep, I can do that. I'm sure it's part of the solution. It's the next part that baffles.

How do you use the known quantities of event start time, duration and...

Thanks, must beetle off and decipher this !

Regards, Greg

Thanks, I guess not. Intersting critique which I didn't agree with.

Of course SQL could do this if "it" wanted to.

The order of the items in the select list is...

Sorted it all out John, thanks for your guidance.

Greg

Hi John,

Well, let me try to explain.

For a t1.hour of zero, I'd want to show the values that row. It's the only row that doesn't need a subtraction, just literal...

OK Thanks,

That is mostly working - except where t1.hour is zero. I think this needs treating as a special case, but I'm not sure how to do this.

Regards, Greg

Hi John,

Umm, would you be able to show the syntax for this ? I've had a go !

select * from dbo.table t left join

(select * from dbo.table ) y...

OK fellows thanks - I'll go for the string rebuild.

Nope, it has no effect. It's definately a datetime field though.

I've also tried preconverting it a char string, and then reconverting back a styled datetime. Still no effect.

Greg

Thanks to you both for adding in extra thought and comment.

Regards, Greg

Me like...

Thanks Cadaver,

I haven't tried this before and it is very, very useful.

All working happily now.

Regards, Greg