USP_DATALIST_CONSTITUENTBYCLIENTUSER

Get the ConstituentID by ClientUsersID.

Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTUSERSID	int	IN	ClientUser

Definition

Copy



CREATE procedure dbo.USP_DATALIST_CONSTITUENTBYCLIENTUSER
(
    @CLIENTUSERSID int
)
as
    set nocount on;

        DECLARE @CONSTITUENTID uniqueidentifier
      SET @CONSTITUENTID = dbo.UFN_CONSTITUENT_GET_BY_CLIENTUSERID(@CLIENTUSERSID)

    SELECT @CONSTITUENTID as CONSTITUENTID