USP_SIMPLEDATALIST_REGISTRATIONINFORMATIONOPTION

CREATE procedure dbo.USP_SIMPLEDATALIST_REGISTRATIONINFORMATIONOPTION
(
    @REGISTRATIONINFORMATIONID uniqueidentifier
)
as begin
    set nocount on;

    declare @RESPONSETYPECODE tinyint;

    select
        @RESPONSETYPECODE = RESPONSETYPECODE
    from dbo.REGISTRATIONINFORMATION
    where ID = @REGISTRATIONINFORMATIONID;

    if @RESPONSETYPECODE = 3 begin            -- Checkbox (Yes/No)

        select
            '11111111-1111-1111-1111-111111111111' as VALUE,
            'Yes' as LABEL

        union all

        select 
            '00000000-0000-0000-0000-000000000000' as VALUE,
            'No' as LABEL;

    end else begin
        select 
            ID as VALUE, 
            NAME as LABEL
        from dbo.REGISTRATIONINFORMATIONOPTION
        where REGISTRATIONINFORMATIONID = @REGISTRATIONINFORMATIONID
        order by SEQUENCE;
    end
end