|
|
|
Junior Member
 
Group: Forum Members
Last Login: 4/22/2007 2:58:00 PM
Posts: 18,
Visits: 1
|
|
i am running job today 2007-02-06...i want to delete data prior to 2005-02-06
please help me in this regard
Thanks in advance
chinna
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/4/2009 12:24:24 PM
Posts: 144,
Visits: 93
|
|
First try to build an SQL select query with a 'where clause' of the date u mentioned.
Check if the data u intend to delete is selected or not.
Then change the select to delete with same where clause.
Test it on few rows first.
If the result is as expected then change the where condition accordingly and then run it on production data.
Hope this helps.
Regards
Ramakrishna Vedantam
Telecom Technology Excellence Group
Tata Consultancy Services
Website: http://www.tcs.com
|
|
|
|