Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Distinct
- [Entry Date]
- FROM
- myTable
- WHERE
- [entry date] >= dateadd(day,datediff(day,1,GETDATE()),0) AND
- [entry date] < dateadd(day,datediff(day,0,GETDATE()),0)
- IF(DATEPART(dw,GETDATE())=1)
- BEGIN
- SELECT *
- FROM myTable
- WHERE [entry date] >= dateadd(day,-3,GETDATE())
- END
- ELSE
- BEGIN
- SELECT *
- FROM myTable
- WHERE [entry date] >= dateadd(day,-1,GETDATE())
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement