Production Ticket(ST) #11307
Snekku - hi, please help to remove 20002_1, thanks
Job Remark:
Ticket Logged Date:
26/03/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
26/03/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
26/03/2024
Resolution:
User request to delete the particular customer where the customer table was back up and delete the customer
Root user- user request
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
History
#1 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Support In Progress to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 26/03/2024
- Resolution updated (diff)
select * from customer where customer_code like '%20002_1%' and org_id= 'Snekku'
-- 7879279ADD2F4E749694B1A48F7FA2AD customer_ id
select * into DMS_EcoSystem_backup_table.dbo._customerBackup20240326
from DMS_EcoSystem.dbo.customer
-- going to delete
DELETE FROM customer WHERE customer_id = '7879279ADD2F4E749694B1A48F7FA2AD';