IF (SELECT COUNT(*) FROM tablename) = (SELECT COUNT(DISTINCT column_of_interest) FROM tablename) SELECT 'FALSE' ELSE SELECT 'TRUE'
select case (select count(*) from (select distinct isValid from TableName) a) when 1 then 'True' else 'False' end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)