USP_RECORDOPERATION_WPBIOGRAPHICAL_DELETE_2

                    create procedure dbo.USP_RECORDOPERATION_WPBIOGRAPHICAL_DELETE_2 (
                        @ID nvarchar(38),
                        @CHANGEAGENTID uniqueidentifier = null
                    ) as begin
                        --check deletion rules, if any


                        declare @WEALTHID uniqueidentifier;


            --ID format should be ID(uniqueidentifier)|IsDemographic(bit)

            declare @BIOID uniqueidentifier,
                    @ISDEMOGRAPHIC bit;

            select @BIOID = cast(SUBSTRING(@ID, 1, 36) as uniqueidentifier), @ISDEMOGRAPHIC = cast(SUBSTRING(@ID, 38, 1) as bit);


            if @ISDEMOGRAPHIC = 1
            begin

                          select @WEALTHID=WEALTHID from dbo.WPBIOGRAPHICALDEMOGRAPHIC where ID=@BIOID;
                          exec dbo.USP_WPBIOGRAPHICALDEMOGRAPHIC_DELETEBYID_WITHCHANGEAGENTID @BIOID, @CHANGEAGENTID;

            end
            else
            begin

                          select @WEALTHID=WEALTHID from dbo.WPBIOGRAPHICAL where ID=@BIOID;
                          exec dbo.USP_WPBIOGRAPHICAL_DELETEBYID_WITHCHANGEAGENTID @BIOID, @CHANGEAGENTID;

            end

                        exec dbo.USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_BIOGRAPHICAL @WEALTHID, @CHANGEAGENTID;

                        return 0
                    end