Re: Deleting with SQL

So for every program, you'll end up with...
either
- >= 30 entries, starting at 2/15/2015
- <= 30 entries, going back as far as needed? (assuming it's possible that
you don't have 30 entries currently logged)



Charles

On Mon, Apr 20, 2015 at 7:38 AM, John R. Smith, Jr. <
smith5646midrange@xxxxxxxxx> wrote:

I have a file that is a log of who ran programs on what date that I need to
purge but the purge has dual criteria. I need to purge based on keeping x
number of entries and entries before x date. For example, I need to keep
all entries after 02/15/2015 AND also the last 30 entries. So, if an entry
falls inside of either of these criteria, I keep it. The user is
immaterial
to the result set.



I'm not sure I have explained that very well but in the event that I have,
can anyone tell me how to do it through SQL?



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.