Ayuda Group By
Publicado por Martin (11 intervenciones) el 20/07/2013 00:06:27
Buenas tardes a todos, tengo un problema para agrupar unos registros de una view de sql server 2008 /r2 y es que no se mucho de sql, la vista funciona perfecto solo que no se donde debo poner la clausula group by para que se agrupe la informacion por vendedor (dbo.gbkmut.res_id ), les dejo mi codigo a ver si pueden orientarme.
Gracias...
Gracias...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SELECT TOP (100) PERCENT dbo.gbkmut.res_id AS SlsRep, reshumres.fullname AS SlsName, dbo.gbkmut.docdate, YEAR(dbo.gbkmut.docdate) AS year,
MONTH(dbo.gbkmut.docdate) AS month, CASE WHEN YEAR(gbkmut.docdate) = YEAR(getdate()) THEN CASE WHEN month(gbkmut.docdate) = month(getdate())
THEN - bdr_hfl ELSE 0 END ELSE 0 END AS MonthToDate, CASE WHEN YEAR(gbkmut.docdate) = YEAR(getdate()) THEN CASE WHEN month(gbkmut.docdate)
<> month(getdate()) THEN - bdr_hfl ELSE 0 END ELSE 0 END AS YearToDate, CASE WHEN YEAR(gbkmut.docdate) <> YEAR(getdate())
THEN CASE WHEN month(gbkmut.docdate) = month(getdate()) THEN - bdr_hfl ELSE 0 END ELSE 0 END AS LastYearMonth, CASE WHEN YEAR(gbkmut.docdate)
<> YEAR(getdate()) THEN CASE WHEN month(gbkmut.docdate) <> month(getdate()) THEN - bdr_hfl ELSE 0 END ELSE 0 END AS LastYear,
CASE WHEN YEAR(gbkmut.docdate) = YEAR(getdate()) THEN CASE WHEN month(gbkmut.docdate) = month(getdate())
THEN '1 MonthToDate' ELSE '1 YearToDate' END ELSE CASE WHEN month(gbkmut.docdate) = month(getdate())
THEN '2 LastMonthToDate' ELSE '2 LastYearToDate' END END AS Period, - dbo.gbkmut.bdr_hfl AS Total
FROM dbo.gbkmut LEFT OUTER JOIN
dbo.humres AS reshumres ON dbo.gbkmut.res_id = reshumres.res_id INNER JOIN
dbo.grtbk ON dbo.grtbk.reknr = dbo.gbkmut.reknr LEFT OUTER JOIN
dbo.Items ON dbo.gbkmut.artcode = dbo.Items.ItemCode
WHERE (dbo.gbkmut.transtype IN ('N', 'C', 'P')) AND (dbo.gbkmut.ReminderCount <= 15) AND (dbo.grtbk.omzrek IN ('J')) AND (dbo.gbkmut.transsubtype <> 'X') AND
(dbo.gbkmut.res_id > 0)
Valora esta pregunta
0