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
mickyT
SSChampion
Points: 10360
More actions
June 26, 2014 at 6:01 pm
#1725310
I'd vote for Lynn's personally. His will return all the rows for Markers that have multiple rows all have Val 'Y'. This would become important if there are other columns to be returned.
For example
'A','Y',0.01
'A','Y',1.24
'B','Y',1.4
'B','N',5.47