USP_SIMPLEDATALIST_STATE_ABBREVIATION

Returns abbreviations for all states for the given country (or all countries if no country supplied).

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive
@COUNTRYID	uniqueidentifier	IN	Country
@USEDEFAULTCOUNTRY	bit	IN	Use default country

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_STATE_ABBREVIATION
(
    @INCLUDEINACTIVE bit = 0,
    @COUNTRYID uniqueidentifier = null,
  @USEDEFAULTCOUNTRY bit = 1
) as
    set nocount on;

    if @COUNTRYID is null and @USEDEFAULTCOUNTRY = 1
        exec @COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

    select
        ID as VALUE,
        ABBREVIATION as LABEL,
        DESCRIPTION
    from dbo.STATE
    where (ACTIVE = 1 or @INCLUDEINACTIVE = 1) and (COUNTRYID = @COUNTRYID or @COUNTRYID is null)
    order by ABBREVIATION