Thursday, September 08, 2016

Query to Delete old data in Treasury module

Sometimes, we may face time out error when we try to delete old data in Treasury module. In that scenario, execute the below mentioned query in query analyser

If you want to delete data prior to 01/01/2008. Type data format as mentioned in the query.Select Treasury database before running this query

Query:

DELETE_TABLE1 '2008-01-01'