Get changes from Audit table

Question

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

Answer 1

0

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.

 SELECT COlUMN1, COLUMN2, COLUMN3  
 FROM TABLEA_LOG  
 WHERE DATE_COLUMN BETWEEN DATE1 AND DATE2

or you could use WHERE DATE_COLUMN > '2012-02-17'

answered Mar 17 '12 at 02:54 PM

Tim
31.5k ● 20 ● 31 ● 116

Thanks Tim. your query did it.

Mar 18 '12 at 10:23 PM denkyira

Glad I could help. Do you mind selecting my response as your answer?

Mar 19 '12 at 01:34 AM Tim

(comments are locked)

Get changes from Audit table

Follow this question

Related Questions