Grant Fritchey (4/27/2015)

---

You need to look to what the execution plan is telling you for how it's going to resolve this query. Your indexes are not being used or the...

ChrisM@Work (4/27/2015)

---

hemal_301080 (4/27/2015)

---

Igor Micev (4/27/2015)

---

Ok,

If you create an index on Lotno,Kapan and Position it should improve the selection in the where condition.

where Lotno=@Lotno

...

Igor Micev (4/27/2015)

---

Ok,

If you create an index on Lotno,Kapan and Position it should improve the selection in the where condition.

where Lotno=@Lotno

...

Still no improvements.

No

I am not updating all rows.

I am just updating a single row if where criteria matches with column 'kapan' and 'lotno'.

Each unique party no from both the tables must be in the result.

For example

VoucherCr

PartyNo Cramount

1 ...

J Livingston SQL (4/12/2013)

---

there appears to be inconsistency in the way you store "item" across the various tables.

Not sure if this down to your real tables or just the...

J Livingston SQL (4/11/2013)

---

Hi

have been at work ...so sorry for delay

I have had to go back thro your various posts in an attempt to get all the details of your...

J Livingston SQL (4/10/2013)

---

just to clarify....you say "voucherPRETSRET doesnt contain any data but needs to be checked"...but there is a PURCHASE RETURN in the sample data for voucher table.....???

maybe sensible...

J Livingston SQL (4/10/2013)

---

just to clarify....you say "voucherPRETSRET doesnt contain any data but needs to be checked"...but there is a PURCHASE RETURN in the sample data for voucher table.....???

maybe sensible...

hemal_301080 (4/10/2013)

---

J Livingston SQL (4/10/2013)

---

just to clarify....you say "voucherPRETSRET doesnt contain any data but needs to be checked"...but there is a PURCHASE RETURN in the sample data for voucher table.....???

maybe...

J Livingston SQL (4/10/2013)

---

just to clarify....you say "voucherPRETSRET doesnt contain any data but needs to be checked"...but there is a PURCHASE RETURN in the sample data for voucher table.....???

maybe sensible...

This is all table i need to check. No further. I did provide only 3 table details so...

J Livingston SQL (4/10/2013)

---

Knowing "everything" may take a little time....its a vast subject...try putting "TSQL" into...

J Livingston SQL (4/10/2013)

---

maybe something along these lines....??

declare @dt1 datetime

declare @dt2 datetime

set @dt1 = '2012-09-01'

set @dt2 = '2012-10-01'

;WITH cte AS

(

SELECT

V1.item,

--V1.voucherno AS VNO,...