I have a table (DataLog) that take log data from a web application.
Data is simply: IdLog - Message - Date
I need to clean this table every week (for example) and save old log entries for every week and save them in other table like:
where 32,33,34 is the week of the year (any other ideas are well accepted).
Is it possible to accomplish it with a trigger?
Thanks a lot in advance.