I have inherited an application which uses a trigger on a table to create an audit table. So there is table A which has a trigger created on it to create table A_log. What I need is an sql statement or a store procedure to show all the changes that occurred for the last 30 days. Any help will be appreciated
asked Mar 17 '12 at 02:26 PM in Default
Can you post the table design? Surely there is a timestamp column in the tablea_log table. A simple where clause filtering on the date range should accomplish what you need.
or you could use WHERE DATE_COLUMN > '2012-02-17'
answered Mar 17 '12 at 02:54 PM