Now that I've got "exists" working, when I put it into my stored procedure, I'm not sure how to work with it from my code. My code is:
Set rst = cnn.Execute("AppealExistsS
P '" & ParcelNo & "', " & TaxYear)
It seems that whether or not a row exists, the recordset "rst" is always closed. So how can I tell if the 'true' from the stored procedure was printed or not, so my code can decide what to do?
ALTER PROCEDURE [dbo].[AppealExistsSP]
@strParNo as varchar(35),
@intTaxYr as smallint
if exists (select * from Appeals where ParcelNo=@strParNo and TaxYear=@intTaxYr)