USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_DELETE

This procedure is used to delete a Prospect Quick Search real estate result.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_DELETE (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            ) as
                set nocount on;

                declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                begin try
                    exec dbo.USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;