Delete unused Practice Areas

--Delete any practice areas that are not used
UPDATE
    __M_Matters_PracticeAreas
SET
    Final_Status = 'Deleted'
WHERE 1=1
    AND Id NOT IN(
        SELECT
            Final_PracticeArea_Id
        FROM
            __M_Matters
        WHERE
            Final_Status != 'Deleted'
    )

• Related Articles

• Synthesize Missing Practice Areas

  The following SQL script will create practice areas where they do not exist in the Matters table. --Synthesize missing practice areas from Matters INSERT INTO __M_Matters_PracticeAreas( Id, Final_Subject ) SELECT DISTINCT Final_PracticeArea_Id, ...

• Convert a Custom Field into a Practice Area

  --The system we are coming from does not have practice areas --however, the client has created a picklist custom field that mimics this. --We are going to convert this custom field into a practice area. --First, populate the practice areas table with ...

• Audit Scripts: General Audit

  After completing a backup there are a number of things that are good to review prior to restoring into the destination system. The script below reviews several of the data points that should be looked at prior to restoring. This script is not ...

• Other: Creating Unique Display Numbers

  The following script will create unique Final_ReferenceCode for all Contacts. It can be easily modified to apply to other record types. Please note that the Final_ReferenceCode that are generated are based on the data in the database. If you are ...

• Tasks and Calendar Entries: Removing Duplicate User Assignments

  Sometimes the same user is included in a calendar event, or assigned to a task, multiple times. This can be a result of User Mapping or data error in the legacy system. Below is an example of how this can happen. A calendar event includes user John ...