Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by StevenC
-
Max Date using Having Criteria
Thanks, Mike great idea. Worked perfectly. -
Max Date using Having Criteria
I can't because I need the max from and to dates that when summed do not equal 0. This is my current SQL, but I can't figure out how to choose the max from and to date row.<br><br>SELECT A.BILL_TO_CUST_ID,TO_CHAR(A.FROM_DT,'YYYY-MM-DD'),<br>TO_CHAR(A.TO_DT,'YYYY-MM-DD'),SUM(... -
Max Date using Having Criteria
Am trying to get the max date from a table where the sum of the rows <> 0. ie<br>Datatable<br>CU From To SUM(Amt)<br>15255 2000-01-01 2000-03-31 12.00<br>15255 1999-10-01 1999-12-31 7,031.00<br>15255 1999-07-01 1999-09-30...
