SELECT STORE_NBR, PIC_NBR, MaxSellPrice, MAX(fromdate) fromdate, MAX(todate) todate
(SELECT STORE_NBR, PIC_NBR, MaxSellPrice, VALUE(fromdate,'0001-01-01') as fromdate, VALUE(todate,'0001-01-01') as todate
FROM [your table name here]
GROUP BY STORE_NBR, PIC_NBR, MaxSellPrice
I think I've got the details right. Give it a spin.
Sorry, one fix, in line.
Computer Systems Manager
5 Manhattan West
New York, NY 10001
Problem with the server or something.
In my sent email as sent, the fix was applied to the SQL which I provided in the _first_ email. However, the second one arrived back in my mailbox as below; with neither the first nor the fixed SQL inline. So:
1. Sorry about three emails on this.
2. Here's the _fixed_ SQL:
If anyone does not see a complete SELECT statement, with a table expression and a GROUP BY clause, please let me know. Maybe this is somehow my error, or a system glitch, but I hope it's resolved now.
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504