Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 4a4c47dbed
Fetching contributors…

Cannot retrieve contributors at this time

12 lines (8 sloc) 0.998 kb
-- This script is used to delete data feeds from SCODS-RC DB for the subscribers with some un-mapped codes
-- that came into the feed on the 25-OCT-2011, those subscribers have been migrated to RC on the 26th of the
-- same month and hence we should remove the data came on the 25th OCT. Those subscribers can be
-- identified with their customerId/accountnumber which begins with CRU
delete [scods-ek]..[ODSservicepackageDelta] where cast(snapshotdate as date) = '2011-10-25' and BillingSubSystemId = '30' and AccountNumber like 'CRU%';
delete [scods-ek]..[ODSservicepackageSnapshot] where cast(snapshotdate as date) = '2011-10-25' and BillingSubSystemId = '30' and AccountNumber like 'CRU%';
delete [scods-ek]..[ODSCustomerDelta] where cast(snapshotdate as date) = '2011-10-25' and BillingSubSystemId = '30' and AccountNumber like 'CRU%';
delete [scods-ek]..[ODSCustomerSnapshot] where cast(snapshotdate as date) = '2011-10-25' and BillingSubSystemId = '30' and AccountNumber like 'CRU%';
Jump to Line
Something went wrong with that request. Please try again.