USP_BBNC_GETCOUNTRIES
Gets list of countries to satisfy the GetTableEntries web service request.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INCLUDEINACTIVE | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_BBNC_GETCOUNTRIES(@INCLUDEINACTIVE bit)
as
set nocount on;
if dbo.UFN_GETLISTSORTMETHOD('COUNTRY') = 0
begin
if @INCLUDEINACTIVE = 0
select
COUNTRY.ID, BBNCCODETABLEIDMAP.ID as BBNCID, COUNTRY.DESCRIPTION, COUNTRY.ISO3166
from
dbo.COUNTRY
inner join dbo.BBNCCODETABLEIDMAP
on COUNTRY.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
and BBNCCODETABLEIDMAP.CODETABLECATALOGID = '6DCD65EA-4D60-4C43-BA04-63DFC0087212'
where
COUNTRY.ACTIVE = 1
order by
COUNTRY.DESCRIPTION
else
select
COUNTRY.ID, BBNCCODETABLEIDMAP.ID as BBNCID, COUNTRY.DESCRIPTION, COUNTRY.ISO3166
from
dbo.COUNTRY
inner join dbo.BBNCCODETABLEIDMAP
on COUNTRY.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
and BBNCCODETABLEIDMAP.CODETABLECATALOGID = '6DCD65EA-4D60-4C43-BA04-63DFC0087212'
order by
COUNTRY.DESCRIPTION
end
else
begin
if @INCLUDEINACTIVE = 0
select
COUNTRY.ID, BBNCCODETABLEIDMAP.ID as BBNCID, COUNTRY.DESCRIPTION, COUNTRY.ISO3166
from
dbo.COUNTRY
inner join dbo.BBNCCODETABLEIDMAP
on COUNTRY.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
and BBNCCODETABLEIDMAP.CODETABLECATALOGID = '6DCD65EA-4D60-4C43-BA04-63DFC0087212'
where
COUNTRY.ACTIVE = 1
order by
COUNTRY.SEQUENCE
else
select
COUNTRY.ID, BBNCCODETABLEIDMAP.ID as BBNCID, COUNTRY.DESCRIPTION, COUNTRY.ISO3166
from
dbo.COUNTRY
inner join dbo.BBNCCODETABLEIDMAP
on COUNTRY.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
and BBNCCODETABLEIDMAP.CODETABLECATALOGID = '6DCD65EA-4D60-4C43-BA04-63DFC0087212'
order by
COUNTRY.SEQUENCE
end