UFN_SOLICITCODE_GETREQUIRED

            create function dbo.UFN_SOLICITCODE_GETREQUIRED()
            returns table
            as
            return
                select SOLICITCODE.ID as SOLICITCODEID
                from dbo.SOLICITCODE
                where SOLICITCODE.EXCLUSIONCODE = 2
                    and SOLICITCODE.ACTIVE = 1