UFN_MKTSEGMENT_ISCONSOLIDATEDVIEWSEGMENT
Returns whether or not a segment is based on the consolidated view.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENT_ISCONSOLIDATEDVIEWSEGMENT]
(
@SEGMENTID uniqueidentifier
)
returns bit
as
begin
declare @SEGMENT_RECORDTYPEID uniqueidentifier;
declare @CV_RECORDTYPEID uniqueidentifier;
select
@SEGMENT_RECORDTYPEID = [IDSETREGISTER].[RECORDTYPEID],
@CV_RECORDTYPEID = (select [RECORDTYPEID] from dbo.[QUERYVIEWCATALOG] where [ID] = dbo.[UFN_MKTRECORDSOURCE_GETCONSOLIDATEDQUERYVIEWID]([MKTSEGMENT].[QUERYVIEWCATALOGID]))
from dbo.[MKTSEGMENT]
left join dbo.[IDSETREGISTER] on [IDSETREGISTER].[ID] = [MKTSEGMENT].[IDSETREGISTERID]
where [MKTSEGMENT].[ID] = @SEGMENTID;
return (case when @CV_RECORDTYPEID = @SEGMENT_RECORDTYPEID then 1 else 0 end);
end