USP_COUNTRY_GETABBREVIATIONLIST

Gets a list of country abbreviations.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN

Definition

Copy



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