UFN_MKTSEGMENT_ISVENDORMANAGEDLIST
Returns whether or not the segment is a vendor managed list segment.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENT_ISVENDORMANAGEDLIST]
(
@SEGMENTID uniqueidentifier
)
returns bit
as begin
declare @ISVENDORMANAGED bit;
if (select [SEGMENTTYPECODE] from dbo.[MKTSEGMENT] where [ID] = @SEGMENTID) = 2
select
@ISVENDORMANAGED = (case when [MKTSEGMENTLIST].[TYPECODE] = 1 then 1 else 0 end)
from dbo.[MKTSEGMENT]
inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
where [MKTSEGMENT].[ID] = @SEGMENTID;
else
set @ISVENDORMANAGED = 0;
return @ISVENDORMANAGED;
end