USP_STATE_DATALIST

Lists all states for a given country.

Parameters

Parameter	Parameter Type	Mode	Description
@COUNTRYID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



CREATE procedure dbo.USP_STATE_DATALIST
(
    @COUNTRYID uniqueidentifier,
    @INCLUDEINACTIVE bit = 0
)    
as 
set nocount on;

if @INCLUDEINACTIVE = 1
    select 
        STATE.ID,
        STATE.DESCRIPTION,
        STATE.ABBREVIATION,
        STATE.ACTIVE
    from dbo.STATE
    where COUNTRYID = @COUNTRYID
    order by DESCRIPTION 
else
    select 
        STATE.ID,
        STATE.DESCRIPTION,
        STATE.ABBREVIATION,
        STATE.ACTIVE
    from dbo.STATE
    where STATE.COUNTRYID = @COUNTRYID and STATE.ACTIVE = 1
    order by STATE.DESCRIPTION