Hi GilaMonster,

Thanks for your comment.

I runned an inventory report from SAP front facade then checked from sql server profiler what was going.

And see that a lot of lines, all of...

All right,

Following is my original code.

What I want is shorten following code with loop code if it is possible and if it is efficient!

SELECT

CODE,

NAME,

[GENEL TOPLAM]=ISNULL((SELECT ONHAND FROM LV_015_01_GNTOTST WHERE...

[/quote]

Yes, that is exactly right. A loop is very inefficient.[/quote]

How percent inefficent?

I mean if I calculate both method how long they takes to complete?

ChrisM@Work (7/10/2015)

---

HerryMarkowitz (7/10/2015)

---

I want INVENNO 101, 102, 103, 104, 105, 106, 107.

But I dont want to see 102, 103, 104, 105, 106 lines in the sql code.

I want a loop...

I want INVENNO 101, 102, 103, 104, 105, 106, 107.

But I dont want to see 102, 103, 104, 105, 106 lines in the sql code.

I want a loop code running...

I am so sorry but my English is not perfect.

Let me tell you what I understand;

A loop code is possible but not efficient.

Is that what you told?

Hi again,

Thanks for the codes.

But your codes are not what I want.

Maybe I am not able to explain my needs because I am very new with SQL coding.

Let me ask...

Hi kyagi.jo,

Thanks for re-organized that code.

But my main question is about how to shorten that code.

I mean I dont want to enter every line from INVENNO 101 to INVENNO 107...