gistfile1.sql

create table Foo (data1 bit, data2 bit, data3 bit, seq int not null)
go

insert into Foo (data1, data2, data3, seq)
values (NULL, 0, 1, 1), (1, NULL, 0, 2), (0, 1, NULL, 3)
go

with unpivoted as (
	select seq, value, col
	from (select seq, data1, data2, data3 from Foo) a
	unpivot (value FOR col IN (data1, data2, data3)) b
), firstSeq as (
	select min(seq) as seq, col
	from unpivoted
	group by col
), data as (
	select b.col, cast(b.value as tinyint) value
	from firstSeq a
	inner join unpivoted b on a.seq = b.seq and a.col = b.col
)
select * from data pivot (min(value) for col in (data1, data2, data3)) d
go

drop table Foo
go