UFN_PDCOMPOSITESEGMENTMAPPING_USESIMPLE
Returns bit for hiding control
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PDCOMPOSITESEGMENTMAPPING_USESIMPLE(@ID uniqueidentifier)
returns bit
with execute as caller
as begin
declare @retval bit = 1
declare @limit int = 50
if (select COUNT(1) from dbo.PDCOMPOSITESEGMENTMAPPINGVIEW where PDACCOUNTTABLESAVAILABLEFORSEGMENTID = @ID ) > @limit
set @retval = 0
return @retval
end