--proveedores cuenta 1.1.9.2.2.1 CARGOS
drop table #datos

SELECT PD_n1, PD_n2, PD_n3, PD_n4, PD_n5, pd_n6, pd_n7, PD_capitulo, SUM(pd_importe) as importe
into #datos
FROM TPolizaDetalle
WHERE (PD_n1 = 1) AND 
      (PD_n2 = 1) AND
      (PD_n3 = 9) AND 
      (PD_n4 = 2) AND 
      (PD_n5 = 2) AND
      (PD_n6 = 1) AND 
      (PD_CargoAbono = 1)
      --AND    (PD_capitulo = 2 OR PD_capitulo = 3 OR PD_capitulo = 5 or pd_capitulo = 6)
GROUP BY PD_n1, PD_n2, PD_n3, PD_n4, PD_n5, pd_n6, pd_n7, 
         PD_CargoAbono, PD_capitulo


select #datos.* , ProNombre Into AgustinProvee1 from  #datos left join TProveedores on #datos.pd_n7 = Tproveedores.ProClave



--proveedores de la cuenta 2.1.5.1.1 ABONOS

drop table #datos2

SELECT PD_n1, PD_n2, PD_n3, PD_n4, PD_n5, pd_n6,  PD_capitulo, SUM(pd_importe) as importe
into #datos2
FROM TPolizaDetalle
WHERE (PD_n1 = 2) AND 
      (PD_n2 = 1) AND
      (PD_n3 = 5) AND 
      (PD_n4 = 1) AND 
      (PD_n5 = 1) AND
      (PD_CargoAbono = 2)
      --AND  (PD_capitulo = 2 OR PD_capitulo = 3 OR PD_capitulo = 5 or pd_capitulo = 6)
GROUP BY PD_n1, PD_n2, PD_n3, PD_n4, PD_n5, pd_n6, 
         PD_CargoAbono, PD_capitulo


select #datos2.* , ProNombre Into AgustinProvee2 from  #datos2 left join TProveedores on #datos2.pd_n6 = Tproveedores.ProClave




-- proveedor 2.1.6.1.2 ABONOS

drop table #datos3

SELECT PD_n1, PD_n2, PD_n3, PD_n4, PD_n5, pd_n6, pd_n7, PD_capitulo, SUM(pd_importe) as importe
into #datos3
FROM TPolizaDetalle
WHERE (PD_n1 = 2) AND 
      (PD_n2 = 1) AND
      (PD_n3 = 6) AND 
      (PD_n4 = 1) AND 
      (PD_n5 = 2) AND      
      (PD_CargoAbono = 2) 
      --AND (PD_capitulo = 2 OR PD_capitulo = 3 OR PD_capitulo = 5 or pd_capitulo = 6)
GROUP BY PD_n1, PD_n2, PD_n3, PD_n4, PD_n5, pd_n6, pd_n7, 
         PD_CargoAbono, PD_capitulo



select #datos3.* , ProNombre Into AgustinProvee3 from  #datos3 left join TProveedores on #datos3.pd_n7 = Tproveedores.ProClave


select pd_n7 , ProNombre , importe into #datos4 from AgustinProvee3
union
select pd_n6 , ProNombre , importe from AgustinProvee2
union
select pd_n7 , ProNombre , importe from AgustinProvee1
order by pd_n7



select sum(importe) as importe , ProNombre , pd_n7 
    into #datos5

   from  #datos4 group by ProNombre , pd_n7 order by sum(importe) desc


select * ,
   direccion1 = (select direccion1 from tproveedores where pd_n7 = ProClave),
   direccion2 = (select direccion2 from tproveedores where pd_n7 = ProClave),
   Rfc = (select Rfc from tproveedores where pd_n7 = ProClave),
   Curp = (select Curp from tproveedores where pd_n7 = ProClave),
   Telefonos = (select Telefonos from tproveedores where pd_n7 = ProClave),
   FisicaOMoral = (select FisicaOMoral from tproveedores where pd_n7 = ProClave)
  into AgustinProveedor
 from #datos5


*************************************

SELECT  sum (pd_Importe)   --pd_capitulo
FROM TPolizaDetalle
WHERE (PD_n1 = 1) AND 
      (PD_n2 = 1) AND
      (PD_n3 = 9) AND 
      (PD_n4 = 2) AND 
      (PD_n5 = 2) AND
      (PD_n6 = 1) AND 
      (PD_n7 = 9326) AND 
      (PD_CargoAbono = 1) 
--AND      (PD_capitulo = 2 OR PD_capitulo = 3 OR PD_capitulo = 5 or pd_capitulo = 6)



SELECT SUM(pd_importe)
FROM TPolizaDetalle
WHERE (PD_n1 = 2) AND 
      (PD_n2 = 1) AND
      (PD_n3 = 5) AND 
      (PD_n4 = 1) AND 
      (PD_n5 = 1) AND
      (PD_n6 = 9326) AND
      (PD_CargoAbono = 2) 
      --AND   (PD_capitulo = 2 OR PD_capitulo = 3 OR PD_capitulo = 5 or pd_capitulo = 6)





SELECT *
FROM TPolizaDetalle
WHERE (PD_n1 = 2) AND 
      (PD_n2 = 1) AND
      (PD_n3 = 6) AND 
      (PD_n4 = 1) AND 
      (PD_n5 = 2) AND      
      (PD_n7 = 9326) AND 
      (PD_CargoAbono = 2) 
       --AND       (PD_capitulo = 2 OR PD_capitulo = 3 OR PD_capitulo = 5 or pd_capitulo = 6)