sql server2000 how do i stop running a stored procedure

[pssheba]

Hi,
My sp creates an error report.
at a certain stage i want it to stop running if there
are errors in thar report.
I wrote:

DECLARE @myparam INTEGER
SELECT @myparam=COUNT(*) FROM report_errors1
  IF (@myParam>0)
    BEGIN
      print 'stop running due to existing errors ! '
      commit
    END

but unfortunately after printing the above message,
the procedure operates next commands.
I wonder if anyone will be kind enough to correct the above
code that is not doing what i wanted it.
Thank a lot !

[iburyak]

Try this:


[PHP]
DECLARE @myparam INTEGER
SELECT @myparam=COUNT(*) FROM report_errors1
IF (@myParam>0)
BEGIN
print 'stop running due to existing errors ! '
Return
END[/PHP]

You ca n simplify this code like this:


[PHP]
IF (SELECT COUNT(*) FROM report_errors1) > 0
BEGIN
print 'stop running due to existing errors ! '
Return
END[/PHP]

Good Luck.