USP_STEWARDSHIPPACKAGEPROCESS_GETPURPOSES

Retrieves fundraising purposes associated with a given stewardship package.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_STEWARDSHIPPACKAGEPROCESS_GETPURPOSES
            (
                @ID uniqueidentifier
            )
            as
                set nocount on;

                select 
                    [DESIGNATIONLEVEL].[ID]                    
                from 
                    dbo.DESIGNATIONLEVEL
                where 
                    [DESIGNATIONLEVEL].[STEWARDSHIPPACKAGEPROCESSID] = @ID;