skmoh2 (1/10/2017)

---

...PSEDOCODE:

Loop1 : Table1_Peggging read Sales Order Material(SKU) Per sales Order

Loop2: Read full table2 for above Material. (Based on our example data you will get 7 records)

...

Arjun Sivadasan (1/9/2017)

---

Well done! I think you only need to add following condition after the group by.

having sum(charge_amount) > 0

Edit: Your original query checks for sum(charge_qty) > 0. Do both...

Multiple rows per day I guess:

WITH charges...

Luis Cazares (1/9/2017)

---

I usually avoid APPLY with correlated suubqueries because it tends to run the query row by row. Obviously, this is...

Luis Cazares (1/9/2017)

---

mishrakanchan86 (1/9/2017)

---

Hi ALl

I have a view which looks something like below.

Select

* from T1 with(NoLock)

Inner Hash Join T2 With (NoLck) on T1.PID = T2.PID

Inner...

The execution plan indicates that the subquery picking up the row with the max date is the most expensive operation.

If charge_date is unique within each partition of a_site_id/charge_code, then this...

LeeFAR (1/6/2017)

---

Thanks Jeff and Chris. I cannot thank you enough for taking your time to help me.

Chris, I did see that the table vars are causing the estimated rows...

LeeFAR (1/6/2017)

---

Here is the t-sql in the store procedure that is running the query that is taking the time. The execution plan that is bad is what is produced...

LeeFAR (1/5/2017)

---

It looks like it may have been a while.

Attached is the query plan. The main query that is the trouble is Query 3. As you...

douglas.t (1/5/2017)

---

Thanks for the effort. Your code is taking longer than mine though on a year's data. I don't know how best to export and post the execution...

https://msdn.microsoft.com/en-us/library/ms188774.aspx

and

https://msdn.microsoft.com/en-us/library/ms190356.aspx

It only has to be reset once it's been set. I...

Run

SET ROWCOUNT 0

and try again.

Can you post, as a .sqlplan attachment, the actual (as opposed to estimated) execution plan for "SELECT query that joins to this table", please? Thanks.

You're reading the base tables quite a few times. You should be able to extract your result set on a single read of the two tables, from what I can...

Run the code of the three relevant CTE's separately to identify which one is responsible, then doublecheck the execution plan. The optimiser throws up false positives from time to time,...