/****** Object:  View [dbo].[V_RC_DEB_NR_PARC]    Script Date: 10/23/2013 16:40:30 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[V_RC_DEB_NR_PARC]'))
DROP VIEW [dbo].[V_RC_DEB_NR_PARC]
GO
GO
GO
GO

CREATE VIEW [dbo].[V_RC_DEB_NR_PARC]
AS
SELECT     CD_EMP, CD_FILIAL, NR_DP, COUNT(NR_DP) AS QT_PARC, ANO, SUM(VLR_DP) AS VLR_TIT
FROM         dbo.RC_DEB
GROUP BY CD_EMP, CD_FILIAL, NR_DP, ANO


