试试这个：
select CircumstanceGroupID from CircumstanceMaster cm left join @given g on cm.CircumstanceType=g.CircumstanceTypeGivenID and cm.Circumstancevalue=g.CircumstancevalueGivengroup by CircumstanceGroupIDhaving sum(case when CircumstancevalueGiven is null then 0 else 1 end) = count(*)
