• crazy_new (1/28/2014)


    Not to sure. There are more than 1 records but there are not duplicates.

    Its just that there can be multiple entries for each address.

    Ok, so when an address is specified and there are multiple rows with that value for ADR1, what determines which row's ADR3 you want?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass