USP_BBNC_GETSTATES
Gets list of states to satisfy the GetTableEntries web service request.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INCLUDEINACTIVE | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_BBNC_GETSTATES(@INCLUDEINACTIVE bit)
as
set nocount on;
if dbo.UFN_GETLISTSORTMETHOD('STATE') = 0
begin
if @INCLUDEINACTIVE = 0
select
STATE.ID, BBNCCODETABLEIDMAP.ID as BBNCID, STATE.DESCRIPTION, STATE.ABBREVIATION
from
dbo.STATE
inner join dbo.BBNCCODETABLEIDMAP
on STATE.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
and BBNCCODETABLEIDMAP.CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
where
STATE.ACTIVE = 1
order by
STATE.DESCRIPTION
else
select
STATE.ID, BBNCCODETABLEIDMAP.ID as BBNCID, STATE.DESCRIPTION, STATE.ABBREVIATION
from
dbo.STATE
inner join dbo.BBNCCODETABLEIDMAP
on STATE.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
and BBNCCODETABLEIDMAP.CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
order by
STATE.DESCRIPTION
end
else
begin
if @INCLUDEINACTIVE = 0
select
STATE.ID, BBNCCODETABLEIDMAP.ID as BBNCID, STATE.DESCRIPTION, STATE.ABBREVIATION
from
dbo.STATE
inner join dbo.BBNCCODETABLEIDMAP
on STATE.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
and BBNCCODETABLEIDMAP.CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
where
STATE.ACTIVE = 1
order by
STATE.SEQUENCE
else
select
STATE.ID, BBNCCODETABLEIDMAP.ID as BBNCID, STATE.DESCRIPTION, STATE.ABBREVIATION
from
dbo.STATE
inner join dbo.BBNCCODETABLEIDMAP
on STATE.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
and BBNCCODETABLEIDMAP.CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
order by
STATE.SEQUENCE
end