Referencias Cruzadas SQL Server 2005

[mash180]

Resuelto, coloco el codigo en caso de que alguien esta tras algo parecido:

set LANGUAGE Spanish
SELECT Estatus, [Mayo-2011] AS Mayo2011, [Junio-2011] AS Junio2011
FROM
(SELECT DateName( Month, Fch) + '-' + DateName( Year, Fch) AS Mes, Count(BDEnv.Fch) AS Contar, BDEnv.Est AS Estatus
FROM BDEnv
GROUP BY DateName( Month, Fch) + '-' + DateName( Year, Fch ), BDEnv.Est
HAVING (((BDEnv.Est)='Enviado'))
UNION ALL
SELECT DateName( Month, FchRec) + '-' + DateName( Year, FchRec) AS Mes, Count(Month([FchRec])) AS Contar, 'Recibido' AS Estatus
FROM BDRec
GROUP BY DateName( Month, FchRec) + '-' + DateName( Year, FchRec)
) Temp
PIVOT
(Sum(Contar)
FOR Mes IN
([Mayo-2011], [Junio-2011])
) AS pvt

Saludos