USP_DATALIST_ADVOCACYGETCOUNTRYANDSTATE
Get Country And State.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COUNTRYID | varchar(50) | IN | COUNTRY ID |
| @STATEID | varchar(250) | IN | STATE ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_ADVOCACYGETCOUNTRYANDSTATE
(
@COUNTRYID varchar(50),
@STATEID varchar(250)
)
as
set nocount on;
Declare @country varchar(20)
Declare @state varchar(20)
select @country = abbreviation from country where ID =@COUNTRYID
select @state = abbreviation from STATE where ID=@STATEID
select @country As Country,@state As State