RE: [sqr-users] Very SQR Beginner

["Larry Roux" <LRoux@syr.edu>]

If you did as below you would get back EVERY row less than or equal to today.  
That might be 1 or 10.  What you really want is the single row with the HIGHEST 
date <= today.  




******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************

>>> mai.to@uth.tmc.edu 12/04/02 03:27PM >>>

Why can't we use something simple like this:

AND B.EFFDT       
       FROM PS_JOB B1
       WHERE B.EFFDT  <= $SysDate)
  AND C.EFFDT 
 FROM PS_JOBCODE_TBL C1
 WHERE C.EFFDT <= $SysDate)

Many Thanks.

Mia

 
>>> This is to use Effective Dating.  PeopleSoft uses Effective Dating
to maintain history.  Using Effective Dating/ Effective Sequencing and
Status you can specify at any time (even up front) which rows of data
are effective at a given time.  For instance, say you know right now
that you will live somewhere from 1/10/2002 to 5/5/2003 then somewhere
else between 5/6/2003 and forward.  In Peoplesoft that is done by
Effective Dating.  The rows of data would look like:

EMPLID  EFFDT     ADDRESS
1234567  1/10/2002 120 Some Address
1234567  5/6/2003   1547 some other address

The code above finds the row that is most effective (that is, less than
or equal to today's date and not in the future).  As of today that row
would be the first one.  As of 5/6/2003 the second address would be in
effect and the code would select that one.



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users