Welcome to Sign in | Help

Re: Script de SELECT ?

  •  02-14-2007, 10:51 AM

    Re: Script de SELECT ?

    am marit putin tabela poate asa ma fac mai bine inteles

    Product  Phase    SerialNumber   ComponentSerialNumber

    A            x            M04                     01212

    A            y            M04                      01212

    A            y            M04                      00000

    A            W           M04                      01212

    CR          x            M04                     0719
    CR          z            M04                     0719
    CR          y            M04                     0777
    CR         W            M04                     0719

    TT          x            Z04                     00333
    TT         z            Z04                     00333
    TT         y            Z04                     00111
    TT        W            Z04                     00111

    cred ca trebuie facut un cursor care trebuie sa-mi ia fiecare inregistrae grupata functie de Product,SerialNumber si sa-mi compare ComponentSerialNumber al fiecarei inregistrare cu ComponentSerialNumber al inregistrarii unde Phase este 'W'

    daca intradevar se poate face cu un cursor atunci am o problema ca nu am mai facut asta :)

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems