USP_SIMPLEDATALIST_CONSTITUENTRELATIONSHIP

This simple datalist returns the relationships for a given constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	CONSTITUENTID

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTRELATIONSHIP(@CONSTITUENTID uniqueidentifier)
                as
                    set nocount on;

                    select    
                        RELATIONSHIP.ID VALUE,
                        NF.NAME + ' - ' + (select DESCRIPTION from dbo.RELATIONSHIPTYPECODE where ID=RELATIONSHIP.RECIPROCALTYPECODEID) LABEL
                    from 
                        dbo.RELATIONSHIP
                        inner join dbo.CONSTITUENT on RELATIONSHIP.RECIPROCALCONSTITUENTID = CONSTITUENT.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                    where 
                        RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
                    order by
                        CONSTITUENT.KEYNAME, 2