USP_DATALIST_CONSTITUENTNAME

Returns a constituent's name given a constituent ID.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENTNAME
                (
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    select NAME,LOOKUPID from dbo.CONSTITUENT where ID = @CONSTITUENTID;