SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[paQryBalances] @pmnAnno INT,@pmIdCuenta VARCHAR(16)=Null
 AS 
 SELECT B.IdCuenta AS CodCuenta,NomCuenta,Tid,B.Nid AS NitTerc,Dv,RazonSocial,Direccion,B.CodMun AS Cod_Mun,Municipio
,B.CodDpto AS Cod_Dpto,Dpto,B.CodPais AS CdPais,SaldoAnt,Debitos,Creditos,SaldoAnt+Debitos-Creditos AS VrNuevoSaldo,BaseGravb
,nAnno,Item,Mayor,Movimiento,Tercero,BaseGravable,Naturaleza,Apellido1,Apellido2,Nombre1,Nombre2,email
 FROM Balances AS B INNER JOIN Puc  AS P ON B.IdCuenta=P.IdCuenta
 LEFT JOIN Terceros AS T ON B.Nid=T.Nid
 LEFT JOIN Depmtos AS D ON B.CodDpto=D.IdDpto LEFT JOIN Municipios AS M ON B.CodMun=M.IdMcp
 WHERE nAnno=@pmnAnno AND (SaldoAnt<>0 OR Debitos<>0 OR Creditos<>0)
 AND (B.IdCuenta=@pmIdCuenta OR @pmIdCuenta IS NULL)
 --ORDER BY B.IdCuenta,RazonSocial