Post reply

Need Some HELP with a Query to help me validate other program.

  • September 3, 2021 at 3:18 pm

    #3926696

    Hello,

    New to SQL Server Central.  I am a JD Edwards Developer by trade, but am in need of assistance with a query for data validation.  I will try to explain but will also add an excel spreadsheet for review.

    I have 2 tables an Item Branch Master and Item Branch Price,

    Pull data from the Item Branch Master for given values,  Branch\Item Type

    From the above result query the Item Branch Price for each Item\Branch from above for only those items who's prices from the different branches are not the same.  It will be 2 branches only.

    Attachments:
    You must be logged in to view attached files.

  • September 3, 2021 at 3:38 pm

    #3926709

    why isn't item 125 different.....50/30  60/28 ?

     

    edit...because of Item_master.Type = 'BIK'?

     

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • September 3, 2021 at 4:40 pm

    #3926720

    Correct, it is a BIK

  • September 3, 2021 at 4:43 pm

    #3926721

    as a developer, I am sure you will appreciate my next question............any chance you can provide set up scripts for your tables and sample data, please...?  (Not everyone is going to open an unknown excel file !)

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • September 7, 2021 at 5:57 am

    #3927402

    J Livingston SQL wrote:

    as a developer, I am sure you will appreciate my next question............any chance you can provide set up scripts for your tables and sample data, please...?  (Not everyone is going to open an unknown excel file !)

     

    Agreed with the above.  Please see the first link in my signature line below with what JLS is talking about.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

You must be logged in to reply to this topic. Login to reply