Stored Procedure to evaluate column if condition is true execute another stored procedure
how would I go about executing a stored procedure on a table if a condition is met.


if exists (select 1 from Supply where SupplyAlert = 'Y')
begin 
exec dbo.sp_SendMail 
end 
else print 'Nothing to send !' 


Remember that CASE is a function and not a control flow statement.