0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

CREATE table #yourtable
    ([Id] varchar(12), [Access] varchar(3), [DB1] varchar(1), [DB2] varchar(1), [DC1] varchar(1))
;
    
INSERT INTO #yourtable
    ([Id],[Access], [DB1], [DB2], [DC1])
VALUES
    ('1','DB1', 'Y',null,null),
    ('1','DB2', null,null,null),
    ('1','DC1', null,null,'Y'),
    ('2','DB1', 'Y',null,null),
    ('2','DB1', null,'Y',null),
    ('3','DC1', null,null,'Y')

;

SELECT ACCESS, MAX(DB1), MAX(DB2), MAX(DC1)
FROM #yourtable
GROUP BY ACCESS

fork query

edited nov 30 20 anonymous

created nov 30 20 jon.doe34997