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

9 lines (5 sloc) 0.631 kb
-- Delete bssid 30 from scods
delete [scods]..[ODSservicepackageDelta] where cast(snapshotdate as date) = '2011-10-25' and BillingSubSystemId = '30' and AccountNumber like 'CRU%';
delete [scods]..[ODSservicepackageSnapshot] where cast(snapshotdate as date) = '2011-10-25' and BillingSubSystemId = '30' and AccountNumber like 'CRU%';
delete [scods]..[ODSCustomerDelta] where cast(snapshotdate as date) = '2011-10-25' and BillingSubSystemId = '30' and AccountNumber like 'CRU%';
delete [scods]..[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.