Vistas de los meses del año.

[Libras]

Código SQL:

SELECT datepart(YEAR, Fecha), SUM(MontoAcumulado), Empleado
FROM Empleados
WHERE datediff(YEAR, Fecha, getdate()) <= 7
GROUP BY Empleado, datepart(YEAR, Fecha)
ORDER BY Empleado, datepart(YEAR, Fecha)
 
UNION
 
SELECT 2013,0,0,0,0,0,0,0,0...0
UNION
SELECT 2014,0,0,0,0,0,0,0,0...0
UNION
SELECT 2015,0,0,0,0,0,0,0,0...0
.
.
.
SELECT 20N,0,0,0,0,0,0,0,0...0
 

Saludos!