USP_COUNTRY_GETLIST

Gets a list of all countries in the system or only active countries.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN

Definition

Copy



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