• Replies 4 replies
  • Subscribers 342 subscribers
  • Views 94 views
  • Users 0 members are here
Options
Related

Bulk remove CSIs

Shelly Binkley (she/her)
$organization

A user accidentally bulk added CSIs to a bunch of records that should not have them.

What is the safest way to bulk remove CSIs? Can I just delete the rows from T_CUST_ACTIVITY in SSMS?

They don't have any actions.

Are there any other tables connected to CSIs that I would need to worry about?

Thanks,

Shelly Binkley

Parents
  • $organization

    A lot of my TNEW Stored Procedures create CSIs and we also had a lot of junk legacy CSIs that we needed clearing out from automated surveys that were blank.

    I do a double check with 

    use impresario

SELECT top 10 * 
FROM T_CUST_ACTIVITY a
LEFT INNER JOIN T_ISSUE_ACTION b ON a.activity_no = b.activity_no

ORDER BY a.activity_no DESC

    Just to be super careful to not leave divorced lines in the action steps: I been known to catching the deleted activity_no from the DELETE action in T_CUST_ACTIVITY and running a follow up DELETE in T_ISSUE_ACTION with those activity_no as a WHERE. When I'm happy with what I've set up I commit the transaction.

Reply
  • $organization

    A lot of my TNEW Stored Procedures create CSIs and we also had a lot of junk legacy CSIs that we needed clearing out from automated surveys that were blank.

    I do a double check with 

    use impresario

SELECT top 10 * 
FROM T_CUST_ACTIVITY a
LEFT INNER JOIN T_ISSUE_ACTION b ON a.activity_no = b.activity_no

ORDER BY a.activity_no DESC

    Just to be super careful to not leave divorced lines in the action steps: I been known to catching the deleted activity_no from the DELETE action in T_CUST_ACTIVITY and running a follow up DELETE in T_ISSUE_ACTION with those activity_no as a WHERE. When I'm happy with what I've set up I commit the transaction.

Children
No Data