Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. SELECT
  2. DATENAME(weekday, factu.fecha) as day,
  3. COUNT(*) AS operations,
  4. SUM(factu.total) AS money,
  5. DATEPART(day, factu.fecha) as date
  6. FROM factu
  7. WHERE factu.fecha >= DATEADD(day, -7, GETDATE())
  8. AND factu.fecha <= GETDATE()
  9. AND (factu.DEPSTATUS = 'paquete-armado' OR factu.DEPSTATUS = 'entregado')
  10. GROUP BY DATENAME(weekday, factu.fecha), DATEPART(day, factu.fecha)
  11. ORDER BY date ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement