Post SQL Test - How to flag the test as a success or failure?

I'm trying to validate that my data in dimension tables hasn't had any business keys sneak in.

I'm just doing:
select column, count()
from table
group by column habving count() > 1

I want the test to fail if any rows are returned and succeed if no rows are returned.

Thanks

Kurt