USP_SIMPLELIST_EVENTREGISTRANTBATCH_ATTENDED

                CREATE procedure dbo.USP_SIMPLELIST_EVENTREGISTRANTBATCH_ATTENDED
                (
                    @REGISTRATIONSTATUSCODE tinyint = 0
                )
                as
                set nocount on;

                /* Be sure to update UFN_EVENTREGISTRANTBATCH_EVENTREGISTRANTATTENDED_TRANSLATION when making changes to this simple list */

                select
                    cast(0 as tinyint) [VALUE],
                    ' ' [LABEL]

                union all
                select
                    cast(1 as tinyint) [VALUE],
                    'Yes' [LABEL]

                union all
                select
                    cast(2 as tinyint) [VALUE],
                    'No' [LABEL]
                where @REGISTRATIONSTATUSCODE not in (0)

                union all
                select
                    cast(3 as tinyint) [VALUE],
                    'No show' [LABEL]