USP_SIMPLEDATALIST_COUNTRY

Returns a list of all countries. Optionally can exclude inactive and/or return abbreviations.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



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