HELP!---Stored Procedure in ASP

This is a multi-part message in MIME format.

------=_NextPart_000_002D_01C65723.B951B750
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello everyone,

I'm writing you because I need help in something that's taking too long. =
I want to build a Stored Procedure to be accessed by an ASP page and I =
need that Stored Procedure to do a couple of things:
1.. Depending on parameters sent by the ASP page, do a SELECT =
statement to a table (tblX01) and if it returns ZERO records, the SP =
should insert some info into other table (tblX02) and if returns ONE =
record, it won't insert into tblX02
2.. Insert some other info in another table (tblX03)
With #2 I don't have a problem, is with #1, how do I know the select =
statement returns ZERO or ONE record? how do I capture that value in the =
Stored Procedure?

Thanks for your prompt response,
SB-R
------=_NextPart_000_002D_01C65723.B951B750
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

1. Depending on parameters sent by the =
   ASP page, do a=20
   SELECT statement to a table (tblX01) and if it returns ZERO records, =
   the SP=20
   should insert some info into other table (tblX02) and if returns ONE =
   record,=20
   it won't insert into tblX02
   
2. Insert some other info in another =
   table=20
   (tblX03)