[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Very SQR Beginner

My sincere thanks to all of you for helping me. 

I now understand this expression "SELECT MAX(B1.EFFDT)"

You all are very kind and patience.  I appreciate your help very much.

Happy Holidays to you all.

Mia

-----Original Message-----
From: Yuri Lakef [mailto:lakef250@yahoo.com] 
Sent: Wednesday, December 04, 2002 2:56 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Very SQR Beginner


The short answer is because you may have multiple historical rows.  
You only want the "current" row, which is defined as the maximum EFFDT
which is less than or equal to today's date.  If it is not <= SYSDATE,
then it is a future-dated row (which is not "current").


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