From your requirements, here's the SQL:

SELECT A.Col1 ,

b.Col1 ,

C.Col1

FROM A

...

If it's splitting the string you need to do, then you can use this piece of code, to split it, and add it to your where statement dynamically.

DECLARE @MfrCodes VARCHAR(8000)

SELECT...

If I were you, I would check the home page of SQL Server Central, there is a headlight talking about how to get good performance, and good protection when using...

Grant Fritchey (5/18/2010)

---

ARE YOU CRAZY?!?!? UPDATING STATISTICS WITH FULL SCAN...

Actually, that's not a bad idea, at all. As you noticed, estimates & actuals are more than a bit off. The...

So now, we know that adding columns to the column list, the Optimizer chose a whole different approach to seek the Events table, can you update the stats on this...

So sorry, I copy pasted the same query twice in SSMS, it is my error, you are right, on the first query, the columns are in the select list. Sorry...

Are the columns SchID and EVId? Because for those plans, they were both commented out when you ran the query. Can we have the plans when those columns are not...

Are those queries on the same server? If no, then I'm guessing 1 of the server needs to have its statistics updated. You can see 1 of the plan seeks...

Can you post the plans? Saved as .SQLPlan and Zipped together, we might be able to see something. Maybe you get a covering index for the first query.

Stefan_G (5/17/2010)

---

The reason the SQL server is using a merge join for joining with ProductToZone is that the cost for reading 653191 rows with sequential IO from the index and...

Lookup "Convert" in Books online, you have plenty formats to use for a date.

cfradenburg (5/11/2010)

---

I can't really explain why this would happen but I do have a recommendation. We've solved similar problems in the past by loading information from some of the...

Sure, here's the full SQL. Thanks for taking a look at it.

DECLARE @CompanyID VARCHAR(4) ,

@DivisionID VARCHAR(4) ,

@DepartmentID VARCHAR(4) ,

...

Edit: My Error

I'm stumped that it needs to scan the whole GICSPFProductToZone table, where a seek could lower the reads drastically, and probably decrease the time of the execution by a fair...