Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: How to select max based on condition.

    Thanks for quick reply!

    But I need both columns i.e. one for alloc_date and other for Days.

    so output should be like:

    c_id ...

    May 19, 2013 at 8:42 pm

    #1616503

  • RE: Best way to do same.

    I need only records from MAIN table for which it did not find respective record in DOC table with CODE = 'I'

    I re-wrote same query like below:

    select main.fileNo from main

    left...

    April 29, 2013 at 12:27 am

    #1610673

  • RE: Optimizing query

    Jon.Morisi (2/27/2013)

    you could read "SUM(CRAMNT) AS CRAMNT FROM myTbl" into a variable and then just select the variable instead of running sum for each row.

    Thanks but can you please guide...

    February 27, 2013 at 8:56 pm

    #1591836

Viewing 3 posts - 1 through 4 (of 4 total)