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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hello everyone,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm writing you because I need help in =
something
that's taking too long. I want to build a </FONT><FONT face=3DArial =
size=3D2>Stored
Procedure to be accessed by an ASP page and I need that Stored =
Procedure to
do a couple of things:</FONT></DIV>
<OL>
<LI><FONT face=3DArial size=3D2>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</FONT>
<LI><FONT face=3DArial size=3D2>Insert some other info in another =
table
(tblX03)</FONT></LI></OL>
<DIV><FONT face=3DArial size=3D2>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?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for your prompt =
response,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>SB-R</FONT></DIV></BODY></HTML>
------=_NextPart_000_002D_01C65723.B951B750--
