Recent content by mullah

Hello Marian: thank you, that works much better :) Tom: I realize that 9.1E is ancient, and upgrade is already planned. UPDATE STATISTICS I ran of course. Thank you both for help !

Hello everyone, Need help from SQL gurus :) Please look at following query: select prh_site, prh_part, prh_rcp_date, sum(prh_rcvd) from pub.prh_hist p1 where p1.prh_rcp_date > sysdate - 30 group by p1.prh_site, p1.prh_part, prh_rcp_date having p1.prh_rcp_date = (select max(p2.prh_rcp_date)...