From what I saw you just took the " from "C:\Program Files\WinRAR\WinRAR.exe"

but Program Files as a space does it work?

full query (still don't work):

set @nomeexacto = (select top 1 s from a1 where s like '%'+@nomeficheiro+'%')

...

This is how the command tries to execute:

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

If I do that. then I have this (below) as the name of the file.

It does not work too..

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

It was one of other procs.

Thanks

But how to do it for several at the same time, like:

exec master.dbo.xp_cmdshell 'rmdir "c:\tempo_SGCTLOCAL\"', no_output

exec master.dbo.xp_cmdshell 'mkdir "c:\tempo_SGCTLOCAL\"', no_output

exec master.dbo.xp_cmdshell 'MOVE '+@caminho+'*.* c:\tempo_SGCTLOCAL', no_output

exec master.dbo.xp_cmdshell 'rd /s/q '+@caminho+'',...

It does not work....

I can not use select into in the cloud (SQL Zure) see error bellow, please:

Statement 'SELECT INTO' is not supported in this version of SQL Server.

Steve Jones - SSC Editor (4/27/2012)

---

Is this a one time operation or something run regularly? If it's the former, I might do a cursor and let it look inside based...

It is a thing that will happens sometimes in a day.

Cursor is bad because of performance

because each one Is a product.

I tryed to add the procedure like :

Begin try

declare @test-2 as integer

insert into facturas

select b.productid, a.quantidade,...

Maybe like this:

Begin try

insert into facturas

select b.productid, a.quantidade, a.desconto, a.iva, a.total, @data, @supplier, @numero, a.preco, @estadofac from temp_facturas1 a,...

Thank you.

Let me just put two more question please.

1) I made it like bellow. What do I put in the catch so that It returns 1 if sucess...

What do you think it's better for this case :

create procedure Facturacao (@maquina varchar(50), @data smalldatetime, @numero varchar(50), @supplier integer, @EstadoFac integer)

as

insert into facturas

select b.productid, a.quantidade, a.desconto, a.iva,...

That will not happen.

I have four tables:

Cars

Trucks

WareHouses

Type of location

But I have another table named Physical_Location

it as OwnID; type of location Id; ID Location