Re: I give up! Help needed on SQL

From: Ed Prochak <prochak_at_my-dejanews.com>
Date: Thu, 22 Apr 1999 17:46:29 GMT
Message-ID: <7fnn9k$ril$1@nnrp1.dejanews.com>

In article <371e3a29_at_newsread3.dircon.co.uk>, "Paul Davies" <cobalt_at_dircon.co.uk> wrote:
> Problem sorted! Thanks to all for the help!
>
> Paul Davies wrote in message <371dc490_at_newsread3.dircon.co.uk>...
> >I give up! I'm trying to translate the Transact SQL below to ORACLE SQL.
> >I've indicated the bits which are causing problems with the /*problem*/
> >flag.
> >
> >The datediff functions are functions I created (with the help of Thomas
> >Kyte) to mimic the Sybase datediff functions.
> >
> >As you'll see from the flag, the problems lie with the embedded correlated
> >subqueries.
> >
> >Any help in rewriting this bit of code would be greatly appreciated.
> >
> >Paul
> >

So what did you do in the end? Which of the suggested solutions worked?

Enquiring minds want to know.

--
Ed Prochak
Magic Interface, Ltd.
ORACLE services
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 22 1999 - 12:46:29 CDT