Check Message #
876903>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.