NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "{{Warning | Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. }} {{Note | The import problem will also occur in c..."
{{Warning | Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. }}
{{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 Upgrade}}
[[Category:SQL Queries]]
[[Category:NAA]]
[[Category:NoPublic]]
{{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 Upgrade}}
[[Category:SQL Queries]]
[[Category:NAA]]
[[Category:NoPublic]]
