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, a.total, @data,...

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

Hi,

I was thinking... in a situation where I want that a database column can only have data that is already on one of other three tables (like a FK), can...

"Stock is in a location, that location has a type "

Sorry, didn't understood you point...

This is a database about stocks (Car parts)

This parts (wheel, tires, etc...) can be located in...

The ideia of the view seems nice

In the location_type you don't have just vheicules...

You have three different records:

1) Cars

2) Trucks

3) WareHouse

This is where the stocks can be

The table Type is location type, not vheicule type.

the file is not open.

It's closed.

Bulk command:

exec('BULK INSERT sessoes1 FROM ''c:\sgrs\SGRS_SGCTCentral_7_20111111102846.rar_Dir\sessao.txt''

with (FIRSTROW =2,FIELDTERMINATOR =''|'',

...

Thanks, great help (the link).

Best Regards,

PR

ad hoc

It's not a job. it's SQL. I need to use xp_cmdshell ( I know the security risks asociated with xp_cmdchell).

Can someone help?

thanks for the tip

For my SQL Server 2000 databases the extended support has ended. Can i get more paying? or i need to migrate?

P.S - Proc 1 as XP_cmdshell commands inside...