I am having a problem retrieving a return value from a stored procedure with
SQLEXEC.

How can I retrieve the return value ?

Many Thanks



The stored proc is as follows:

create procedure [dbo]._bspNextAuditNo
with encryption
as

set nocount on

update Entities
set
DblSpare1 = IsNull(DblSpare1, 0) + 1

declare @NextAuditNo int
set @NextAuditNo = (select top 1 DblSpare1 from Entities)
return @NextAuditNo