Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT
- CLAIM_NO,
- ModifiedBy,
- ClaimType,
- ClaimStatus,
- EmailAddress,
- FROM EP_ADMIN_ITEM_REMINDER
- WHERE Status = 1 AND DATEDIFF(Day,DateAdded,getdate()) = 3
- SELECT DISTINCT
- CLAIM_NO,
- ModifiedBy,
- ClaimType,
- ClaimStatus,
- EmailAddress,
- FROM EP_ADMIN_ITEM_REMINDER
- WHERE Status = 1 AND DATEDIFF(Day,DateAdded,getdate()) > 2
- WHERE [DateAdded] > DATEADD(day, -3, getdate())
Add Comment
Please, Sign In to add comment