USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONLEVELGOALPURPOSE

The load procedure used by the view dataform template "Fundraising Purpose Goal Purpose View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PURPOSEID	uniqueidentifier	INOUT	Purpose ID
@PURPOSENAME	nvarchar(100)	INOUT	Purpose name

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONLEVELGOALPURPOSE
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @PURPOSEID uniqueidentifier = null output,
                    @PURPOSENAME nvarchar(100) = null output
                )
            as
            begin
                select 
                    @DATALOADED = 1,
                    @PURPOSEID = dl.ID,
                    @PURPOSENAME = dl.NAME
                from DESIGNATIONLEVEL dl
                    inner join DESIGNATIONLEVELGOAL dlg on dl.ID=dlg.DESIGNATIONLEVELID
                where dlg.ID=@ID
            end