thanks all for the help. I needed to add the begin and end around the ifs, just like yall said.  heres the working code:

declare @ReturnValue int

IF EXISTS (

      SELECT

          *

     ...

ill be at work around 1pm cst tomorrow and ill let you know

I'm a little confused.  Could you please be more specific? WHere should I add begin/end?