select * from AgustinProveedor order by importe desc
select * from AgustinProveedorAnterior


/*
update AgustinProveedor
set iva = (select PorcentajeIva from AgustinProveedorAnterior where AgustinProveedorAnterior.pd_n7 = AgustinProveedor.pd_n7)


update AgustinProveedor
set iva = null



select 
     iva = (select PorcentajeIva from AgustinProveedorAnterior where AgustinProveedorAnterior.pd_n7 = AgustinProveedor.pd_n7)
from AgustinProveedor

*/

14622

select   SolIva from TSolDePagoMto where (SolCodBeneficiario = 14622) --and (SolProvOEmp = 0) 
select  FactorIva from TgtoForMatPorAlmDet where gmpaCodProv = 14622


select pd_n7 ,
     iva = (select top 1  SolIva from TSolDePagoMto where (SolCodBeneficiario = pd_n7) and (SolProvOEmp = 0) )
from AgustinProveedor

select pd_n7 ,
     iva = ( select top 1  FactorIva from TgtoForMatPorAlmDet where gmpaCodProv = pd_n7 )
from AgustinProveedor  

select top 10 SolProvOEmp , SolCodBeneficiario , SolIva from TSolDePagoMto




update AgustinProveedor
set iva =  (select top 1  SolIva from TSolDePagoMto where (SolCodBeneficiario = pd_n7) and (SolProvOEmp = 0) )


update AgustinProveedor
set iva = ( select top 1  FactorIva from TgtoForMatPorAlmDet where gmpaCodProv = pd_n7 )
where iva is null


select * from AgustinProveedor order by importe desc


update AgustinProveedor
   set ImporteNeto = ROUND( (importe * (100 - iva) / 100) , 2)
where iva is not null

print ROUND(10.258,2)