Start Processing : 2025-03-15 01:38:52<BR>0 rows affectedUPDATE tv_dnc 
SET 
    _DNCType = CASE
        WHEN _callresultreason = 'Chose Another Vendor' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Recently Purchased' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Satisfied with Current Solution' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Not a Fit Industry' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Will Not Consider Client' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Not a DM Location' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Not a Fit Install' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Current Customer' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Currently Working with Client' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Going Out of Business' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Recently Implemented' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Not a Fit Geo' THEN 'OrgRemoval'
        WHEN _callresultreason = 'Not RPC' THEN 'ContactRemoval'
        WHEN _callresultreason = 'No Longer with Company' THEN 'ContactRemoval'
        WHEN _callresultreason = 'Not in Service' THEN 'ContactRemoval'
        WHEN _callresultreason = 'Not RPC Referral' THEN 'ContactRemoval'
        WHEN _callresultreason = 'Do Not Call' THEN 'ContactRemoval'
        ELSE 'Needs Review'
    END<BR>[1] 0 seconds -> -1 rows affected<BR>INSERT INTO tv_dnc_contacts 
SELECT * FROM tv_dnc WHERE _DNCType = 'ContactRemoval'<BR>[2] 0 seconds -> -1 rows affected<BR>INSERT INTO tv_dnc_org 
SELECT * FROM tv_dnc WHERE _DNCType = 'OrgRemoval'<BR>[3] 0 seconds -> -1 rows affected<BR>