UFN_PDACCOUNTSEGMENTMAP_ISMAPPED2
Returns map status of LongDescription ID
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DESCRIPTIONID | nvarchar(36) | IN | |
| @ISDEFAULT | bit | IN | |
| @STRUCTUREID | nvarchar(36) | IN |
Definition
Copy
create function dbo.UFN_PDACCOUNTSEGMENTMAP_ISMAPPED2(@DESCRIPTIONID nvarchar(36),@ISDEFAULT bit,@STRUCTUREID nvarchar(36))
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 = @DESCRIPTIONID and PDACCOUNTSTRUCTUREID = cast(@STRUCTUREID as uniqueidentifier) )
set @retval = 1
return @retval
end