USP_SIMPLEDATALIST_COUNTRY_ABBREVIATION

Returns abbreviations for all countries.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_COUNTRY_ABBREVIATION(@INCLUDEINACTIVE bit = 0) AS
    if dbo.UFN_GETLISTSORTMETHOD('COUNTRY') = 0
        begin
            if @INCLUDEINACTIVE = 0
                select ID as VALUE, ABBREVIATION as LABEL from dbo.COUNTRY where ACTIVE = 1 order by DESCRIPTION
            else
                select ID as VALUE, ABBREVIATION as LABEL from dbo.COUNTRY order by DESCRIPTION
        end
    else
        begin
            if @INCLUDEINACTIVE = 0
                select ID as VALUE, ABBREVIATION as LABEL from dbo.COUNTRY where ACTIVE = 1 order by SEQUENCE, DESCRIPTION
            else
                select ID as VALUE, ABBREVIATION as LABEL from dbo.COUNTRY order by SEQUENCE, DESCRIPTION
        end