NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Note | The import problem will also occur in cases where one enumvalue is active and the others are inactive. The import problem does not apply to CDFs. }}
If this SQL gives a result set, contact your GICHD IM advisor:
<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 Technical Notes}}
[[Category:SQL Queries]]
[[Category:NAA]]
