Advertisement
Guest User

Untitled

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