Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sbf
  • Content: Threads
  • Order by date
  1. sbf

    Prevoius maximum

    Hi Everyone, I need help CRW 8.5 on SQL Server. I have the following data set: Start End Lane RT_NR Diff (NR) 10,00 17,00 NR 17 14,00 15,00 NR 17 14-17= -3 16,00 19,00 NL 17 18,00 20,00 NR 20 18-17= 1 21,00 24,00 NL 20 23,00 25,00 NR 25 23-20= 3 23,00...
  2. sbf

    First in - first out

    Hi Everyone I want to calculate the store value, based on the “first in - first out principle” for each item. When items are issued the earliest(oldest) items are taken from the store. lot issue date quant price curbal value A RECEIPT 01-12 7 10 7 7*10=70 B RECEIPT 02-12 4...
  3. sbf

    Calculate a value based on a previous value

    Hi Everyone, I need help I have the following records in a table and want to calculate the last column “value” The calculation is dependent of the change of ‘issuetype’ RECEIPT. Item issuetype date quant u_price cur_bal value 0001 RECEIPT 01-09 12 20 12 12*20=240 0001...
  4. sbf

    Montly rating using the most recent value if no data for the month

    Hi Everyone, I need help ! I have the following records in a table: GlAccont Rating Ratingdate 1111 4 22-JAN-2003 1111 3 13-FEB-2003 1111 4 05-MAY-2003 1111 2 06-JUL-2003 2222 3 12-DEC-2002 2222 2 07-MAY-2003 2222 4...

Part and Inventory Search

Back
Top