Create a query that only shows active records based on start date, duration, and true/false
- by Chris
I'm trying to piece together a dynamic view that will give a list of all emails that are still being rejected.
Table structure:
EmailName - varchar(150) - An email address
StartRejection - Date - Day to start rejecting email
Duration - Small Int - Duration of rejection
IsIndefinate - Bit - Is the rejection 'non date range specific' but indefinate