Dear All,

i am sorry, i placed with wrong room

thank's

hi lutzm,

hi dave,

base on links:

http://www.simple-talk.com/sql/performance/set-based-speed-phreakery-the-fifo-stock-inventory-sql-problem/

finaly i found the script to solve my case. Thank's

hi dave,

would you answer this question , please......

when i try to create Index [kur_items] at temp_stok (i use sql server 2005)

-------------------------------------------

CREATE NONCLUSTERED INDEX [kur_items]

ON [dbo].[temp_Stok]

...

hi dave,

i'm lonely in my office. may you guide me, step by step to solve my case ,dave?

thank's

Dave Ballantyne (1/3/2011)

---

Happy new year to you too,

The key is now to find the first/earliest 'IN' stock movement , that still has stock remaining in the warehouse. Since...

hi dave, happy new year....

first , i...

hi Dave,

my item stock is about 5000 items, thank's for your help

this is my script for your answer:

select count(distinct item) from tbStockList

hi dave,

i have try your script at the point article. but the result still not same on my case.

would you write the query base on my case? thank's

regards,

newbi......

hi.....

i have read your pointer article...., but i am still not understand to be implement into my case.....

would you guide me , to solve my case ?

thank's

LutzM (12/29/2010)

---

Please explain the business rules on how to get your expected result.

Issues I'm struggling with:

- Item a starts with an amount of 10, but it shows an amount of...

Kit G (12/29/2010)

---

I'll be the first to ask... is this a homework problem? My apologies if it isn't, it just has that feel.

That question aside, I'm not sure what...