Re: Manipulate data use TSQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 02/26/04 

Date: Wed, 25 Feb 2004 20:30:40 -0500

How about :

SELECT Acct, MAX(Aff) AS Aff, MAX(Auto_) AS Auto_, MAX(Signa) AS Signa
    FROM AALS
        GROUP BY Acct 

-- 
Andrew J. Kelly  SQL MVP
"culam" <anonymous@discussions.microsoft.com> wrote in message
news:1a6801c3fc06$7060a0d0$a301280a@phx.gbl...
>
> Original Data
> Acct        Aff  Auto_ Signa
> ----------- ---- ----- ----- 
> 1           NO   YES   NO
> 1           YES  YES   NO
> 2           NO   NO    YES
> 2           NO   YES   NO
>
> DESIRE RESULT
> Acct        Aff  Auto_ Signa
> ----------- ---- ----- ----- 
> 1           YES   YES   NO
> 2           NO    YES   YES
>
> DDL
>
> IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
>       WHERE TABLE_NAME = 'AALS')
>    DROP TABLE AALS
>
> CREATE TABLE AALS(Acct INT, Aff CHAR(4), Auto_ CHAR(4),
> Signa CHAR(4))
> INSERT INTO AALS
> VALUES(1, 'NO', 'YES', 'NO')
> INSERT INTO AALS
> VALUES(1, 'YES', 'YES', 'NO')
> INSERT INTO AALS
> VALUES(2, 'NO', 'NO', 'YES')
> INSERT INTO AALS
> VALUES(2, 'NO', 'YES', 'NO')
>
> Any help is greatly appreciated,
>
> Culam
>