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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. StevenC

    Max Date using Having Criteria

    Thanks, Mike great idea.  Worked perfectly.
  2. StevenC

    Max Date using Having Criteria

    I can't because I need the max from and to dates that when summed do not equal 0.&nbsp;&nbsp;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(...
  3. StevenC

    Max Date using Having Criteria

    Am trying to get the max date from a table where the sum of the rows &lt;&gt; 0. ie<br>Datatable<br>CU From &nbsp;&nbsp;&nbsp;To &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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...

Part and Inventory Search

Back
Top