USP_DATALIST_SELECTIONMERGESELECTIONS

Displays the selections created from merged selections.

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SELECTIONMERGESELECTIONS
(
    @RECORDTYPEID uniqueidentifier
)
as
begin
    set nocount on;

    select 
        IDSETREGISTER.ID as ID,
        IDSETREGISTERMERGE.NAME as NAME
    from
        dbo.IDSETREGISTER
        inner join dbo.IDSETREGISTERMERGE on IDSETREGISTER.ID = IDSETREGISTERMERGE.IDSETREGISTERID
    where
        IDSETREGISTER.RECORDTYPEID = @RECORDTYPEID and IDSETREGISTER.ACTIVE = 1 and IDSETREGISTER.ISSYSTEM = 0
end