Forum Replies Created

Viewing 4 posts - 76 through 80 (of 80 total)

  • RE: Enter maximum value on the basis of 2 independent tables.

    anujkumar.mca - Saturday, February 10, 2018 5:44 AM

    Hi Folks, 
    I stuck in a puzzle, please suggest a way to resolve this. 

    I have 2...

    February 10, 2018 at 6:28 am

    #1979341

  • RE: Data Analysis

    mcmu4256 - Friday, February 9, 2018 1:15 PM

    Please help!  I have the query below.  The output is as follows:
    ProcessDate--------------AccountNumber--------------CloseDate-----------Mem_years--------------credit_loan----chk_acct
    20180208-----------------------323314------------------------NULL--------------------23------------------------500------------------X
    20180208-----------------------323314------------------------NULL--------------------23-----------------------NULL----------------X

    But I just want...

    February 9, 2018 at 7:11 pm

    #1979334

  • RE: Summing Sales Data

    Including the case statement for the "Actual Sales" column would ensure you get the sales for the first 5 months.
    Currently the "ActualSales" for the rest of the months is...

    February 8, 2018 at 10:00 pm

    #1979168

  • RE: space issue in display

    If i got your question right, you wish to have a total of 40 spaces in your output after concatenating column1 and column2?

    If so this should help you.

    February 8, 2018 at 9:08 pm

    #1979163

Viewing 4 posts - 76 through 80 (of 80 total)