USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_SELECT

This procedure is used to select real estate results for a Prospect Quick Search criteria.

Parameters

Parameter	Parameter Type	Mode	Description
@PARTIALINFORMATIONSEARCHCRITERIAID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_SELECT (
                    @PARTIALINFORMATIONSEARCHCRITERIAID uniqueidentifier
                ) as
                set nocount on;

                select
                        PISRRE.[ID],
                        PISRRE.[FIPSCODE],
                        PISRRE.[ASSESSORSPARCELNUMBER]
                from
                    dbo.[PARTIALINFORMATIONSEARCHRESULT_REALESTATE] PISRRE
                where
                    PISRRE.[PARTIALINFORMATIONSEARCHCRITERIAID] = @PARTIALINFORMATIONSEARCHCRITERIAID;

                return 0;