USP_SIMPLEDATALIST_ADDRESSTRANSLATION
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ADDRESSTRANSLATION | nvarchar(150) | IN | |
| @COUNTRYID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_ADDRESSTRANSLATION(
@ADDRESSTRANSLATION nvarchar(150),
@COUNTRYID uniqueidentifier
)
as
set nocount on;
if @COUNTRYID = '00000000-0000-0000-0000-000000000000'
set @COUNTRYID = null;
select dbo.UFN_ADDRESS_STANDARDIZE(@ADDRESSTRANSLATION, @COUNTRYID) as VALUE;