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...

I don't have XP, SQL Server is doing this on W2k3.

Yes, I have the folder:

c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - T - 1118.rar_Dir

It's as you told:

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 - T...