Thanks guys,  Got it! and it works 

I can actually do it either way.

This is exactly what I am running.

CREATE   PROCEDURE dbo.offer_ckcd

@account numeric

AS

-- DECLARE AND INITIALIZE

DECLARE @response int

SET @response=0

-- BEGIN LOGIC

  BEGIN

  EXEC @response = dbo.active_ckg @account

  IF @response = 1

  --...

Thank you so much for both replys to my post;

What I want is for the store proc to evaluate all of the conditions; if they are true or if...