Hi

Here is the DDL

:CREATE TABLE [dbo].[FicheirosImportar](

[SessaoInicio] [varchar](5) NULL,

[SessaoFim] [varchar](5) NULL,

[Codrf] [varchar](5) NULL,

[Nome] [varchar](500) NULL,

[Caminho] [varchar](500) NULL,

[Valido] [bit] NULL,

[Ordem] [int] NULL

) ON [PRIMARY]

This is the entire code:

ALTER PROCEDURE [dbo].[spSGCT_VALIDA_SGCTLocais] (@DB as varchar(50))

AS

BEGIN

set nocount on

...

I made like this:

SET @SQLString = 'select @maxVal = isnull(max(cod_sincronismo_fim),0)

...

Can you give me an example?

Daxesh Patel (6/4/2012)

---

As I have mentioned this in my first comment,

you cannot set a variable using exec('') since the command will be executed in different session, you have to...

If I add the execute command to the query, when I execute the procedure I receive the following:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '='.

Command:

exec('set '+@MaxTotalidade+...

if I do like this:

set @cmd = ('set '+@MaxTotalidade+ ' = (select isnull(max(cod_sincronismo_fim),0) as maximo

...

Yes.

Thanks.

But still I have a problem.

exec('set '+@MaxTotalidade+ ' =(select convert(bigint,isnull(max(cod_sincronismo_fim),0))

...

Now it works

To work I had to put like this:

select @cmd = 'C:\"Program Files"\WinRAR\WinRAR.exe x -u '+@NomeFinal+' '+@DirectoriaFinal+''

This is what i get:

'C:\Program' is not recognized as an internal or external command,

'C:\Program' is not recognized as an internal or external command,

It say "Command(s) completed successfully."

No erros message is displayed

Very strange.....

My command is now as :

"C:\Program Files\WinRAR\WinRAR.exe" x -u "c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - T - 1118.rar" "c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426...