Post reply

Locating Groups of Data with Missing Value

  • November 25, 2009 at 2:54 pm

    #137157

    I have a set of records that contains like sets of data. For example:

    [ID] [WO#] [OPERATION]

    1 1234 Grinding

    2 1234 LaserCutting

    3 1234 Inspection

    Now in most sets there is an operation called ReWork, but some do not have this step.

    I need to find all the unique work order numbers that do not have this step so I can correct them.

    Is there any way to do this with a script for example? Any help will be greatly appreciated.

    Jeff

  • November 25, 2009 at 10:33 pm

    #1084445

    Yes... write an exclusive self join or a union between two queries on the same table using EXCEPT.

    Since you're new to the forum, take a look at the article in the first link in my signature lines below. Post data that way and people will be on your problem like white on rice to give you a working, tested, coded answer.

    --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 2 posts - 1 through 2 (of 2 total)

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