UFN_PDACCOUNTSEGMENTMAP_ISMAPPED
Returns map status of LongDescription ID
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @LONGID | nvarchar(36) | IN | |
| @ISDEFAULT | bit | IN |
Definition
Copy
create function dbo.UFN_PDACCOUNTSEGMENTMAP_ISMAPPED(@LONGID nvarchar(36),@ISDEFAULT bit)
returns bit
with execute as caller
as begin
declare @retval bit = 0
if @ISDEFAULT = 1
set @retval = 1
else
if exists(select * from dbo.PDACCOUNTSEGMENTMAPPING where LONGDESCRIPTIONID = @LONGID )
set @retval = 1
return @retval
end