inventory system

• rahma_hassan71

  Newbie

  Points: 9

  More actions

  September 3, 2010 at 8:15 am

  #226520

  i am trying to find any articles about how to improve inventory system in distribution center i cant fined any thing here shloud be from 2002 to2010 can any one help pleas.

  thanks.

  hassan

• Jeff Moden

  SSC Guru

  Points: 1004339

  More actions

  September 3, 2010 at 2:54 pm

  #1216426

  If you spend a little time reading it, you find the following quite interesting.

  http://ask.sqlservercentral.com/questions/826/the-fifo-stock-inventory-sql-problem

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• dave-318819

  SSC-Addicted

  Points: 411

  More actions

  January 11, 2011 at 3:06 am

  #1271770

  Improve inventory system? Are you looking at ways to optimise your server performance or finding ways to improve your design?

  If you're looking for an inventory database sample, try browsing a book from Smashwords. The book is about accounting database design, and there is some tutorial on table designing and query scripts for inventory system.

  Hope you'll find it useful:-)