USP_DATAFORMTEMPLATE_EDITLOAD_MULTIPLEGROUPMEMBERROLES

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@MEMBERNAME	nvarchar(700)	INOUT
@GROUPROLES	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MULTIPLEGROUPMEMBERROLES(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @MEMBERNAME as nvarchar(700) = null output,
    @GROUPROLES xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @GROUPROLES = dbo.UFN_CONSTITUENT_GETGROUPROLES_TOITEMLISTXML(@ID)

        select @MEMBERNAME = DISPLAYNAME.NAME
        from dbo.GROUPMEMBER
            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(GROUPMEMBER.MEMBERID) DISPLAYNAME
        where GROUPMEMBER.ID = @ID

    return 0;