RE: RecordCount is 0 en Stored Procedure

2002-04-18 Thread Tony_Petruzzi
nd @@Error) immediately after the operation in question - the next command resets these values. Shawn Grover -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:31 AM To: CF-Talk Subject: RecordCount is 0 en Stored Procedure Hi all: I got thi

RE: RecordCount is 0 en Stored Procedure

2002-04-18 Thread Shawn Grover
Error) immediately after the operation in question - the next command resets these values. Shawn Grover -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:31 AM To: CF-Talk Subject: RecordCount is 0 en Stored Procedure Hi all: I got this que

RE: RecordCount is 0 en Stored Procedure

2002-04-18 Thread Voris, Jim
PROTECTED]] Sent: Thursday, April 18, 2002 12:31 PM To: CF-Talk Subject: RecordCount is 0 en Stored Procedure Hi all: I got this query in transac-SQL. I would like to know when the result recorset is 0. I wrote this tricky code down here but I think is wrong. Any ideas??. Thanks in advance friends. Mario

RecordCount is 0 en Stored Procedure

2002-04-18 Thread Mario Martinez R.
Hi all: I got this query in transac-SQL. I would like to know when the result recorset is 0. I wrote this tricky code down here but I think is wrong. Any ideas??. Thanks in advance friends. Mario SELECT @Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@Fi