mpharo Posted April 3, 2008 Share Posted April 3, 2008 Hello, I am witing a new application that generates information daily. Right now I have it setup that the initial information is set for a start date and end date with an active and deactive flag. Basically what I need to do is query for all of the information that is greater than the start date and less than the end date where they are active. But the catch is that there is also a sunday-saturday flag to be set for each day. So each day where Monday is set to active and it is within the start date and end date I need to generate information, the Sunday thru Saturday flags can be changed in the middle of the duration. What I was thinking if doing was havin a daily script that runs that filters out the information for each day and then generates the report based on that information, that way if a monday is now deactive that was previously active I still have a record of all of the previous mondays that were active. In total this will generate about 1000 records per day and much less on the weekends. Is this the correct way to go about this? is there another way? I am open to ideas. Thanks in advance, Quote Link to comment Share on other sites More sharing options...
mpharo Posted April 3, 2008 Author Share Posted April 3, 2008 anyone have an idea? Quote Link to comment Share on other sites More sharing options...
aschk Posted April 3, 2008 Share Posted April 3, 2008 We'd have a better idea if you supply the DDL (data definition language)/schema, with some sample data, and an example output. Quote Link to comment Share on other sites More sharing options...
gluck Posted April 9, 2008 Share Posted April 9, 2008 Hello, I am witing a new application that generates information daily. Right now I have it setup that the initial information is set for a start date and end date with an active and deactive flag. Basically what I need to do is query for all of the information that is greater than the start date and less than the end date where they are active. But the catch is that there is also a sunday-saturday flag to be set for each day. So each day where Monday is set to active and it is within the start date and end date I need to generate information, the Sunday thru Saturday flags can be changed in the middle of the duration. What I was thinking if doing was havin a daily script that runs that filters out the information for each day and then generates the report based on that information, that way if a monday is now deactive that was previously active I still have a record of all of the previous mondays that were active. In total this will generate about 1000 records per day and much less on the weekends. Is this the correct way to go about this? is there another way? I am open to ideas. Thanks in advance, Come with a basic structure and we'll help you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.