Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. SELECT Distinct
  2. [Entry Date]
  3.  
  4. FROM
  5. myTable
  6.  
  7.  
  8. WHERE
  9.  
  10. [entry date] >= dateadd(day,datediff(day,1,GETDATE()),0) AND
  11. [entry date] < dateadd(day,datediff(day,0,GETDATE()),0)
  12.  
  13. IF(DATEPART(dw,GETDATE())=1)
  14. BEGIN
  15. SELECT *
  16. FROM myTable
  17. WHERE [entry date] >= dateadd(day,-3,GETDATE())
  18. END
  19. ELSE
  20. BEGIN
  21.  
  22. SELECT *
  23. FROM myTable
  24. WHERE [entry date] >= dateadd(day,-1,GETDATE())
  25. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement