Prueba con algo asi :)
Código SQL:
Ver originalCREATE TABLE #temp
(
id_cod INT,
fecha datetime,
decript VARCHAR(100),
vta_b INT,
vta_n INT,
dto INT,
canti INT
)
INSERT INTO #temp(id_cod,Fecha,decript,Vta_b,Vta_n,dto,canti) VALUES (1,'04/20/2011','Lapiz azul',10.00,10.00,0.00,1)
INSERT INTO #temp(id_cod,Fecha,decript,Vta_b,Vta_n,dto,canti) VALUES (2,'05/20/2011','Lapiz negro',5.00,5.00,0.00,2)
INSERT INTO #temp(id_cod,Fecha,decript,Vta_b,Vta_n,dto,canti) VALUES (3,'05/03/2011','Lapiz azul',10.00,8.00,2.00,1)
INSERT INTO #temp(id_cod,Fecha,decript,Vta_b,Vta_n,dto,canti) VALUES (4,'05/05/2011','Lapiz negro',10.00,8.00,1.00,2)
SELECT mes,decript,SUM(Vta_b) AS vta_b, SUM(Vta_n) AS vta_n,SUM(dto) AS dto, SUM(canti) AS canti FROM(
SELECT datename(mm,fecha) AS mes,* FROM #temp) t1 GROUP BY mes,decript
Saludos!!