I'm trying to RETURN an integer variable called @iReturnCode after comparing
2 columns from 2 different tables after comparing the columns. I'm not real
familiar with using RETURN for this type of purpose. If the 2 columns aren't
equal, I'd like to RETURN a 1, if they are equal, just RETURN 0.

Can some shed some light? I commented the 2 places below where I'm trying to
RETURN the @iReturnCode variable.

-- CODE: ****************************************

BEGIN

declare @dtStartDate datetime, @dtEndDate datetime
set @dtStartDate = '20080717'
set @dtEndDate = '20080717'

declare @TimeRun1 int, @TimeRun2 int, @iReturnCode int

IF @dtStartDate > @dtEndDate
   SELECT 50002 As iRetCode,
    'Start Date  must be before
     than End Date' As sErrMsg
ELSE
    BEGIN

   SET @TimeRun1 = (SELECT SUM(time_run) FROM myTable1)
   SET @TimeRun2 = (SELECT SUM(time_run) FROM myTable2)

   If @TimeRun1 <> @TimeRun2
    -- RETURN @iReturnCode = 1
   ELSE
    -- RETURN @iReturnCode = 0

   PRINT @TimeRun1

    END

END