Purging old transactions

uttam,

Are you referring to the store level or HQ level? Also are you referring like the sales Journal?

Ed

"uttam" wrote:

Hi Ed, Thanks for replying.....I am referring to the Store Ops....but knowing HQ would not be bad either.....and yes i am referring to the sales journal.....thanks again....

Best regards, Uttam

"Ed" wrote:

Hi Ed,

Definitely backup and do this outside store hours, but this query should do the trick. Replace the date with first day you want to keep. This example would remove all journal entries prior to Sept. 1, 2007.

delete journal where time < ?9/1/2007?

If you have a long history, this can free up a huge amount of space in your database. In that case, you may want to perform a 'shrink' operation after running the query.

Jim

"uttam" wrote:

Here is an SQL query for deleting journals more than a year old.

You can alter the number of days to whatever you require.

DELETE Journal WHERE time < getdate()-365

Disclaimer:

Always test any queries that modify data on a test database prior to running on your live data to ensure the desired results.

Always back-up prior to running any SQL delete queries on your live data.

Regards Michael (Brisbane, Australia)