Re: sql that is making my brain hurt
From: David Lord <dlordster_at_gmail.com>
Date: Wed, 20 Feb 2008 16:46:14 +0000
Message-ID: <649030d80802200846u60bc05a8i32895b3c1b64c44d@mail.gmail.com>
) a
join dcl_1 b
Date: Wed, 20 Feb 2008 16:46:14 +0000
Message-ID: <649030d80802200846u60bc05a8i32895b3c1b64c44d@mail.gmail.com>
Chris,
Does this do it:
select b.resource_id,
b.start_res + a.hrs
from (
select rownum / 24 hrs
from user_objects a
) a
join dcl_1 b
on b.start_res + a.hrs >= b.start_res
and b.start_res + a.hrs < b.end_res
;
Regards
David Lord
On 20/02/2008, Stephens, Chris <chris_stephens_at_admworld.com> wrote:
> What I need is 1 row per hour from the start date up to and not
> including the end date.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 20 2008 - 10:46:14 CST