Hi,

This thing can be acheived using one querry also. I am not sure that all the three conditions need to be checked in the same table or different tables.

-- If it is same table

SELECT COUNT(TOP 1 1) AS Check

FROM MyTable

WHERE Checks1 = true

OR Checks2 = true

OR Checks3 = true

-- If it is in different tables

SELECT COUNT(TOP 1 1) AS Check -- 'Here i have used 1 as a contant value so that it

returns 1 if any of ur conditions are satisfied

FROM MyTable1

WHERE Checks1 = true

OR EXISTS(SELECT 1

FROM MyTable2 WHERE Checks2 = true)

OR EXISTS(SELECT 1

FROM MyTable3 WHERE Checks3 = true)