Home Forums SQL Server 2012 SQL Server 2012 - T-SQL check that column has one and only one value and the value is the value I want RE: check that column has one and only one value and the value is the value I want

  • July 4, 2014 at 3:22 am

    #1727035

    SELECTMarker

    FROMdbo.TEMP_A

    GROUP BYMarker

    HAVINGSUM(CASE WHEN Val = 'Y' THEN 0 ELSE 1 END) = 0

    N 56°04'39.16"
    E 12°55'05.25"