So what I mean:

I have stored procedure like this:

CREATE PROCEDURE sp_Example
@param1 NVARCHAR(20) = '',
@param2 DATE = ''
AS
BEGIN
   IF (SELECT COUNT(*) FROM Table1 WHERE (Name = @param1 OR @param1 = '') AND (StartDate = @param2 OR @param2 = '')) > 2
   BEGIN
      SELECT Name, Date, Price, Etc
      FROM Table2
      WHERE (Name = @param1 OR @param1 = '') AND (StartDate = @param2 OR @param2 = '')
   END

   IF (SELECT COUNT(*) FROM Table1 WHERE (Name = @param1 OR @param1 = '') AND (StartDate = @param2 OR @param2 = '')) < 2
   BEGIN
      SELECT Name, Date, Price, Etc
      FROM Table3
      WHERE (Name = @param1 OR @param1 = '') AND (StartDate = @param2 OR @param2 = '')
   END
END

So in stored procedure are some input parameters and they are passed into IF statement.