USP_DATAFORMTEMPLATE_VIEW_REVENUEBATCHGROUPMEMBERINFO

The load procedure used by the view dataform template "Revenue Batch Group Member View Form"

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUEBATCHGROUPMEMBERINFO
                (
                    @ID uniqueidentifier,
                    @NAME nvarchar(700) = null output,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @DATALOADED bit = 0 output
                ) as
                begin
                    set nocount on;

                    if exists(select top(1) ID from dbo.GROUPMEMBER where GROUPMEMBER.ID = @ID)
                        select
                            @DATALOADED = 1,
                            @NAME = CONSTITUENT_NF.NAME,
                            @CONSTITUENTID = GROUPMEMBER.MEMBERID
                        from 
                            dbo.GROUPMEMBER 
                        outer apply
                            dbo.UFN_CONSTITUENT_DISPLAYNAME(GROUPMEMBER.MEMBERID) CONSTITUENT_NF                           
                        where
                            GROUPMEMBER.ID = @ID

                    if @DATALOADED = 0
                        if exists(select top(1) ID from dbo.BATCHREVENUECONSTITUENTGROUPMEMBER where BATCHREVENUECONSTITUENTGROUPMEMBER.ID = @ID)
                            select
                                @DATALOADED = 1,
                                @NAME = coalesce(CONSTITUENT_NF.NAME, BATCHREVENUECONSTITUENT.NAME),
                                @CONSTITUENTID = coalesce(BATCHREVENUECONSTITUENT.EXISTINGCONSTITUENTID, BATCHREVENUECONSTITUENT.ID)
                            from
                                dbo.BATCHREVENUECONSTITUENTGROUPMEMBER
                            left outer join
                                dbo.BATCHREVENUECONSTITUENT on BATCHREVENUECONSTITUENTGROUPMEMBER.MEMBERID = BATCHREVENUECONSTITUENT.ID
                            outer apply
                                dbo.UFN_CONSTITUENT_DISPLAYNAME(BATCHREVENUECONSTITUENT.EXISTINGCONSTITUENTID) CONSTITUENT_NF
                            where
                                BATCHREVENUECONSTITUENTGROUPMEMBER.ID = @ID;

                    return 0;
                end