Is there anything wrong with using... count(*) from tables when all you are concerned is to check if rows exists or not. Then after getting the count(*) in a variable, you are simply checking the @variable > 1 for an if ... else statement?
Are there any other suggestion to accomplish this?
To expand on spirit1's excellent suggestion - EXISTS is optimised to stop searching the table as soon as it finds the first row that matches whatever criteria you use. COUNT(*) will count every row that meets the criteria which at worst will be a scan of the entire table.