How do I get these select statements into two separate variables or comparison

[Bebe]

I have a stored procedure. I need to get the two select statements into variables. I need to compare both counts and create and error rountine if they do not much. I am enclosing the code, but would also like help on the error handler;

Please assist thanks

CREATE procedure dbo.SpLaLaMonitor
@TestDate smalldatetime= '11/24/00 11:00'

SELECT COUNT (*)as 'what does text here produce?' from dev1.dbo.vw_look_txn Where vendor_err='x' and created_dt>@TestDate

SELECT COUNT (*) as 'what does text here produce?' from Merchant_Order mo join Order_Line ol on ol.Order_ID = mo.Order_ID Where La_To_La=1 and mo.Modified_Date>@TestDate


EXEC dbo.SpLaLaMonitor

--GO

[Serge]

You can do something like this:

CREATE procedure dbo.SpLaLaMonitor 

@TestDate smalldatetime= '11/24/00 11:00' 

AS

Declare @Result1 int
Declare @Result2 int

SELECT
    @Result1 = COUNT(*) 
FROM
    dev1.dbo.vw_look_txn 
WHERE
    vendor_err='x' and created_dt > @TestDate 

SELECT
    @Result2 = COUNT(*) 
FROM
    Merchant_Order mo join Order_Line ol on ol.Order_ID = mo.Order_ID 
WHERE
    La_To_La = 1 and mo.Modified_Date > @TestDate 


If @Result1 <> @Result2
    Begin
        Return 1000 --Return any error number you want
    End
Else
    Begin
        Return 0  --Return success number here
    End

[Bebe]

"I wanna be like Mike"

Quote from Volcano when Tommy Lee Jones saves city from Volcano and reroutes it to ocean.


You are awesome thanks!!!