And SOOOOOO little time to do it in, right? David
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Saturday, March 05, 2005 2:30 PM Subject: [RBG7-L] - Re: Date Function > Well, David, not cover to cover but I have read a good bit of it already > <g>. I was looking for a date function of some kind, not a select, > otherwise that's normally where I look first!. And I promise to look up > Unit 2 on Monday as the book is at the office. I have soooo much to > learn!!! > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. > > Blocker > > Sent: Saturday, March 05, 2005 8:28 AM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Re: Date Function > > > > Claudine > > > > It appears you haven't yet read the Advanced SQL book you ordered from me > > a > > while back (grin!) > > > > See Unit 2, SELDEMO.RMD, examples 4.33 - 4.36 > > > > David > > > > David Blocker > > [EMAIL PROTECTED] > > 781-784-1919 > > Fax: 781-784-1860 > > Cell: 339-206-0261 > > ----- Original Message ----- > > From: "claudinerobbins" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[email protected]> > > Sent: Friday, March 04, 2005 7:06 PM > > Subject: [RBG7-L] - Re: Date Function > > > > > > > Thanks Sami and Larry, > > > > > > And the winner is: > > > > > > BROWSE * FROM D_Invoice_Status D1 WHERE invoice_id = 33979 and > > Inbox_State > > = > > > 2 AND NOT EXISTS (SELECT * FROM > > > D_Invoice_Status WHERE invoice_id = d1.invoice_id AND State_Changed_Dt < > > > D1.State_Changed_Dt) > > > > > > Claudine :) > > > > > > -----Original Message----- > > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence > > > Lustig > > > Sent: Friday, March 04, 2005 5:36 PM > > > To: RBG7-L Mailing List > > > Subject: [RBG7-L] - Re: Date Function > > > > > > > bro * fro d_invoice_status where inbox_state = 2 and > > > > (lmin(state_changed_dt)) > > > > > > BROWSE & FROM D_Invoice_Status D1 WHERE Inbox_State = 2 AND + > > > NOT EXISTS (SELECT * FROM D_Invoice_Status + > > > WHERE State_Changed_Dt < D1.State_Changed_Dt) > > > > > > will show the single row with the lowest State_Changed_Dt and > > > > > > BROWSE & FROM D_Invoice_Status D1 WHERE Inbox_State = 2 AND + > > > NOT EXISTS (SELECT * FROM D_Invoice_Status + > > > WHERE PrimaryKeyCol = PrimaryKeyCol AND + > > > State_Changed_Dt < D1.State_Changed_Dt) > > > > > > will show the lowest-dated row for each PrimaryKeyCol value. > > > -- > > > Larry > > > > > > > >
