USP_DATALIST_PLANNEDGIFT_SITES

A datalist of sites for a given planned gift.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_PLANNEDGIFT_SITES(@PLANNEDGIFTID uniqueidentifier)
                as
                    select 
                        UFN_PLANNEDGIFT_GETSITES.ID,
                        SITE.NAME
                    from
                        dbo.UFN_PLANNEDGIFT_GETSITES(@PLANNEDGIFTID)
                    inner join 
                        dbo.SITE on SITE.ID = UFN_PLANNEDGIFT_GETSITES.SITEID
                    order by
                        SITE.NAME;