>Hello.
>
>I have the next store procedure:
>
>CREATE PROCEDURE dbo.abc2
>@server varchar(20),
>@base varchar(20),
> AS
>DECLARE @pnCampo3 numeric(19,5)
>DECLARE @cad varchar(1000)
>set @pnCampo3 = 0.0
>set @cad='select MAX(NOTEINDX) from ['+@server+'].['+@base+'].[dbo].[SY03900] '
>exec(@cad)
>set @pnCampo3=@pnCampo3+1.0
>GO
>
>but I need get the value of [exec(@cad)] in a variable in order to add (1) to the result, for example if [exec(@cad)] = 5 I need get 5+1=6.
>
>I put somthing like this but is a error:
>set @pnCampo3=exec(@cad)
>
>How can I do this?


Try:

CREATE PROCEDURE dbo.abc2
@server varchar(20),
@base varchar(20),
AS
DECLARE @pnCampo3 numeric(19,5)
DECLARE @Nextvalue int
DECLARE @cad varchar(1000)
set @pnCampo3 = 0.0
set @cad='select @TestMe = MAX(NOTEINDX)+1 from ['+@server+'].['+@base+'].[dbo].[SY03900] '
SET @Nextvalue = 0
sp_executeSql @cad,'@TestMe int OUTPUT', @TestMe = @Nextvalue OUTPUT
SELECT @Nextvalue
set @pnCampo3=@pnCampo3+1.0

(not tested)