alter table MANUTENCAO ADD PRODUTONOESTOQUE INT 
go


select PRODUTONOESTOQUE  from MANUTENCAO 

select filial ,quant ,estestrate, quantrma,qtdereserv,* from itemfilest 
where codpro ='00002' and filial in ('01','02')


--update itemfilest set quant ='100',estestrate ='100',quantrma='0',qtdereserv ='0'where codpro ='00002'