Re: sql statement - Why no work? - solved!

[Sam Spritzer <teknogeek9@YAHOO.COM>]

Andrew,
I can see you are using Peoplesoft.  Those date variables will work if you
include the datetime.sqc and apply the date variables to that routine.  Perhaps
that is why it didn't work considering all of the correct suggestions by
everyone else?
SQRly yours,
Sam



--- Andrew Lin <alin@TECHNEGLAS.COM> wrote:
> Hi all,
>
> I got great suggestions from Bill, teknogeek, samir, ginger, and
> denise.
>
> Everytime I got a new suggestion, I thought, "YES, that must be
> it...."
>
> Then I tried it, and it still didn't work.  However in the process of
> trying out
> different things I narrowed the problem  down to:
>
>   AND C.EFFDT =
>        (SELECT MAX(EFFDT)
>         FROM   PS_JOB
>         WHERE  EMPLID    = $EmplID
>           AND  EMPL_RCD = #Empl_RcdNo
>           AND  EFFDT    <= $Pay_End_Dt)    <------- sqr didn't like
> this
>    AND C.EFFSEQ =
>        (SELECT ... <snip>)
>    AND D.EFFDT =
>        (SELECT MAX(EFFDT)
>         FROM   PS_BEN_PROG_PARTIC
>         WHERE  EMPLID    = $EmplID
>           AND  EMPL_RCD = #Empl_RcdNo
>           AND  EFFDT    <= $Pay_End_Dt)   <------- or this
>
> Anyway, I ended up declaring a date variable and using that instead,
> which is weird since I've never run into this problem before with
> comparing dates to string-dates.
>
> Thanks all!
>
> PS: Just got an e-mail from Taj.Mohammed; he nailed it on the head.


=====
************************************************************
"In the beginning, there was something...which exploded yet, they find nothing."

__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/