Thank you for your response, I hope you are feeling better.

I get a syntax error:

Incorrect syntax near 'W_PARAM_G'

Forgot to add teh zipped file, sorry all

ZIP file contains:

All scripts needed to create thetables and indexes

Copy of the Execution Plan

Copy of the results of the query

Copy of the Client Statistics

I saved the Plan with the extension like you said, unfortunately, that extension is not one supported by tSQL ServerCentral and it will not attach it. I tried it...

WOW, came in this morning and I cannot believe how many people are just willing to help. In the past I never asked for help and just tried to figure...

Thank you very much.

I appreciate the response. I wish I had a copy of Quest Software, it seesm to help out sometimes by rewriting the query and trying it out....

Is this post considered dead now? When I first opened it I got all kinds of responses. Now after 2 days not even a hello. LOL

SELECT

CHF.CONTACT_WID , COUNT(DISTINCT CHF.SOURCE_WID) , COUNT(DISTINCT isnull(POH.OFFER_WID, 0)) - SUM (CASE WHEN...

GSquared,

my e-mail is pino_daddy@yahoo.com. If there are more things you would like me to provide to you, just let me know. I know you said to use the...

GSquared,

As you can probably tell, I am not a SQL expert, not a SQL intermediate, not even a SQL novice.

If you could provice that query again the way you wrote...

Here are the table definitions for the 3 tables:

CREATE TABLE [dbo].[W_CAMP_HIST_F](

[ACCNT_WID] [numeric](10, 0) NOT NULL CONSTRAINT [DF__W_CAMP_HI__ACCNT__787EE5A0] DEFAULT (0),

[CALL_STATUS_WID] [numeric](10, 0) NOT NULL CONSTRAINT [DF__W_CAMP_HI__CALL___797309D9] DEFAULT (0),

[CAMPAIGN_WID] [numeric](10,...

I saved the execution plan into a file, but I do not see any way of including it in here.

The following queries return the counts shown below:

select count(*) from W_SRC_OFFR_H;

select...

The WHERE clause uses the PARAM table to compare the ETL_PROC_WID is in one table or the other to see if it is a change to an order.

If a customer...

This pretty good, it returns in 16 minutes, real nice improvement. You gave it a good shot, but the results are wrong because I need it to use the W_PARAM_G.ETL_PROC_WID...

This pretty good, it returns in 16 minutes, real nice improvement. You gave it a good shot, but the results are wrong because I need it to use the W_PARAM_G.ETL_PROC_WID...