Thank you so much for posting a reply.. I must appologize as I had double posted.. I couldn't find the right forumn to post to thus I put it here......

DJ,

Thanks for helping take this to the next level... after playing with it it turns out that the command must be executed in this manner...

EXEC stpMySproc ' WHERE CompanyName...

quote:

---

You cannot create a parameter from multiple parts in the stored procedure call. You have to build it ahead of time. Architectural...

Marek,

Thanks for responding, Let's see

Select Distinct A.ccID, Min(A.ccDateTime) as ccDateTime, max(A.StatusID) as StatusID From HAAScc.dbo.tbl_ccStatus A Where A.StatusID = 2 Group by A.ccID

I'm Maxing...

Marek,

Thanks for posting and for providing details about how long a similar procedure would run on more records... yikes!!! you have many more records than what I'm working...

 Here is a listing of what my table rows are like (sorry I misunderstood the first few posts I thought you ment...

Here is the query plan after I took out the second vw_Contacts table refrence...

  |--Sort(ORDER BY:([].[ContactName] ASC, [CONTACT1].[Company] ASC, [Expr1025] ASC))

...

Thanks for the pointers that you guys have provided... I guess it's just a trial and error type of learning... What I know about writting SQL has been...

Thanks for your indept reply I made the initial changes and in process of moving the table.. (later today) The table only contains 245...

OK, new plan, I went into all the CCID columns for cc_Status cc_Notes cc_Assigned and made them clustered.. it seems as if it took and this is my plan now......

DOH!

Thanks...

I added an additioanl clause for when the SHIPPED date is NULL, so it looks like this...

IF IsNull(DTSSource("SHIPPED")) THEN

DTSDestination("SHIPPED") = DTSSource("SHIPPED")

ELSE

IF DateValue(DTSSource("SHIPPED")) < DateValue("12/31/1900") THEN

...

I wanted to say thanks for taking the time to help me out... I am currently re-reading one of my SQL books "Using SQL Server 7.0" under the...

This is an updated Execution plan after minimizing the * down to columns...

StmtText ...

This is the exact code for that view... I am using the OpenQuery instead of the full linked name " SELECT COLLIST FROM Service.dbname.dev_rede.tbl_Contacts" because the Front End application (an...

No problem, I've included both the sproc and a view that is used, the only other views are the ones pulling data from a remote server (sql 2000) as Select...