Here is the estimated execution plan as a jpg. I don't think I can upload the actual sqlplan file on here.

Setting the recursive option to false stops the problem but the right updates are not occuring.

Here is some more information on what we are trying to do. When TitleDatareplicationDateTime is...

Thank you for the help. You are right. I didn't quite phrase it correctly when I first brought up what I was trying to do. Thanks for baring with me.

I...

I don't think that is quite right. Now the TitleReferenceNumber = 872168536C does not get it's time updated when a change is made to the corresponding record on Title_LastDocumentChangeDate.

Basically, I...

Sorry...another question on this one...

How would I add a case statment to the Where so that the clause I have specified is only evaluated in the case where there is...

I think I got it. I just changed yours slightly to be the following:

BEGIN

SET NOCOUNT ON

UPDATE TitleDataReplicationDateTime

SET...

Here is some data from DB_Title..DTI_SHORT_LEGAL_TEXT_DISPLY:

0120014;72

0020213;20C

0120070;1;1

9921326;12

0420009;48

7521106;3;3

9920020;1;3

7521308;1;3

7921543;1;2

Basically...if an update happens to any record in Title_LastDocumentChangeDate we want to check this field for corresponding records in DB_Title. If we find a record...

Thanks for the help. That looks kind of like what I am trying to get at...but I tested it and it's not updating TitleReplicationDateTime.

The results are as follows

TitleReferenceNumber LastDocumentRegistrationDate

-------------------- ----------------------------

0020033CS1...

Jack....you are awesome!!! Thank you so much.

I think the issue is resolved based on my testing. I have to wait until April 16 for the client to get back and...

Hi Matt,

I got the following errors when trying to create a temp table in that view:

Msg 156, Level 15, State 1, Procedure vwMinHTOXLinc, Line 20

Incorrect syntax near the keyword 'drop'.

Msg...

Statistics have been updated using Update Statistics - twice now.

Indexes have been rebuilt.

I dropped and readded the views as Prakash suggested. It made no difference. The query is still dreadfully...

There are 3 non clustered on DB_PROPRTY

CREATE NONCLUSTERED INDEX [IX_DB_PROPRTY_LincNbrEtc] ON [dbo].[DB_PROPRTY]

(

[DPR_LINC_NBR] ASC,

[DPR_NON_PATENT_IND] ASC,

[DPR_MUNC_CODE] ASC,

[DPR_PROPRTY_PARCEL_ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING...

Sorry...see this one.

USE [ALTA_Staging]

GO

/****** Object: Table [dbo].[DB_HTXLINC] Script Date: 11/29/2007 15:27:25 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[DB_HTXLINC](

[P_K] [numeric](16, 0) NOT NULL,

[N_K_HTXTITL_HTXLINC] [numeric](16, 0)...

Here are the indexes on those tables:

USE [ALTA_Staging]

GO

/****** Object: Table [dbo].[DB_HTXLINC] Script Date: 11/29/2007 15:20:55 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[DB_HTXLINC](

[P_K] [numeric](16, 0)...

Hi Matt,

I ran just the selects in the views themselves and they seemed to take just as long as running the entire query. I think we are right to be...