I'm querying in incident data and the incident created on time stamp. During load I want to associate my data with their appropriate time frames. Example: if an incident was created today it would belong to last 24 hours, today, and last 30 days but if an incident was created a week ago it would only belong to last 30 days. Is there a way to loop through the data and create a second table that tracks the incident number and the multiple time frames it should appear in when selected?
