Forum Replies Created

Viewing 6 posts - 76 through 81 (of 81 total)

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

    How about an identity column for each of the tables then?. 
    Or do you have a need that the value of the orderno being used in TAB_A should NOT be...

    February 10, 2018 at 8:35 am

    #1979347

  • 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: Duplicating Data To Each Saturday That a Promotion Is Live For

    This was removed by the editor as SPAM

    February 9, 2018 at 2:00 am

    #1979191

  • 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 6 posts - 76 through 81 (of 81 total)