USP_WEALTH_CREATE

Creates an entry in the WEALTH table for a given constituent, if one doesn't already exist.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_WEALTH_CREATE (
                @CONSTITUENTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            ) as begin
                set nocount on;

                if (not exists(select 1 from dbo.WEALTH where ID=@CONSTITUENTID))
                    insert into dbo.WEALTH
                        (ID, ADDEDBYID, CHANGEDBYID)
                    values
                        (@CONSTITUENTID,@CHANGEAGENTID,@CHANGEAGENTID);

                return 0;
            end;