USP_SIMPLEDATALIST_MANAGEPURPOSEDESIGNATIONINFORMATIONACTIONS

CREATE procedure dbo.USP_SIMPLEDATALIST_MANAGEPURPOSEDESIGNATIONINFORMATIONACTIONS
(
  @NAMECODE integer = null
)
as
begin
  set nocount on;
    if @NAMECODE = 6        --IsRevenueDesignation

        select
            0 as VALUE,
            'Set to new value' as LABEL 
    else if @NAMECODE is not null
        select
            1 as VALUE,
            'Add value if it does not exist' as LABEL 
        union all
        select
            2 as VALUE,
            'Add value if it does not exist and overwrite existing values' as LABEL 
        union all
        select
            3 as VALUE,
            'Delete value if it exists' as LABEL
end