NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
"public".imsmaenum.enumcategory ASC,
"public".imsmaenum.enumvalue ASC
</pre>
This query list the duplicate enumvalues created after the upgrade scripts. Note that there might be more enumcategories that the four above:
<pre>
SELECT
imsmaenum.enumcategory,
imsmaenum.enumvalue,
COUNT (imsmaenum.imsmaenum_guid)
FROM
imsmaenum
GROUP BY
imsmaenum.enumcategory,
imsmaenum.enumvalue
HAVING
COUNT (
imsmaenum.imsmaenum_guid
) > 1
ORDER BY
imsmaenum.enumcategory ASC,
imsmaenum.enumvalue ASC
</pre>
{{NavBox Upgrade}}
