SQL - ayuda con consulta Pivot

INVOICE No.	NC DOC	NC VALUE	ND DOC	ND VALUE	RC DOC	RC VALUE	INVOICE

40842	         137	       130130	140	         60000	   3	    130130	780776

40842	         137	       130130	141	         85060	   3	    130130	780776

40842	         138	      -130130	140	         60000	   3	    130130        780776

40842	         138	      -130130	141	         85060	   3       130130        780776

40842	         139	       190130	140	         60000	   3	    130130	780776

DOC TYPE	 DOC. No.	DOC VALUE

NC DOC	137	         130130.00

NC DOC	138	         -130130.00

NC DOC	139	          190130.00

ND DOC	140	          60000.00

ND DOC	141	          85060.00

RC DOC	3	          130130.00

SELECT

	C.Ano,

	C.Mes,

	CASE T .TipoPersona

	  WHEN 'N' THEN (rtrim(T .PrimerNombre) + ' ' + rtrim(T .SegundoNombre)

		+ ' ' + rtrim(T .PrimerApellido) + ' ' + rtrim(T .SegundoApellido))

	  ELSE (rtrim(T .RazonSocial))

	END AS Nombre,

	C.NroDocumento,

	NCE.NroDocumento AS NotasCredito,

	NDE.NroDocumento AS NotasDebito,

	RCE.NroDocumento AS RecibosCaja,

	NCE.ValorDocumento AS [VLR NOTA CREDITO],

	NDE.ValorDocumento AS [VLR NOTA DEBITO],

	RCE.ValorDocumento AS VlrReciboCaja,

	C.ValorDocumento,

	C.Debitos,

	C.Creditos,

    C.FechaEmision,

	C.FechaVencimiento

FROM CarteraCxC					 AS C

INNER JOIN Terceros				 AS T	 ON C.IdTercero = T.IdTercero

INNER JOIN NdCxCEncabezado		 AS NDE	 ON T.IdTercero = NDE.IdTercero

INNER JOIN NcCxCDetalle			 AS NCD	 ON C.IdCarteraCxC = NCD.IdCarteraCxC

INNER JOIN NcCxCEncabezado		 AS NCE  ON NCD.IdNcCxCEncabezado = NCE.IdNcCxCEncabezado

INNER JOIN RecibosCajaDetalle    AS RCD  ON C.IdCarteraCxC = RCD.IdCarteraCxC

INNER JOIN RecibosCajaEncabezado AS RCE  ON RCD.IdReciboCajaEncabezado = RCE.IdReciboCajaEncabezado

INNER JOIN NdCxCDetalle			 AS NDD  ON NDE.IdNdCxCEncabezado = NDD.IdNdCxCDetalle.