USP_DATALIST_CONSTITUENT_SITES

A datalist of sites for a given constituent.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_CONSTITUENT_SITES(@CONSTITUENTID uniqueidentifier)
                as
                    select 
                        UFN_CONSTITUENT_GETSITES.ID,
                        SITE.NAME
                    from
                        dbo.UFN_CONSTITUENT_GETSITES(@CONSTITUENTID)
                    inner join 
                        dbo.SITE on SITE.ID = UFN_CONSTITUENT_GETSITES.SITEID
                    order by
                        SITE.NAME;