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 Mike Lewis 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: *

  1. huong30

    table function

    I had an existing function that return table value, which used to calculated the algorithm, work fine for individual input. However I had the need to run for the whole table...which I supposed I can do a while loop. I was wondering if there are other way to do this. thx... declare @id int set...
  2. huong30

    FIFO transactions result

    Hi Sqlsister, Base on the table, I like to create a function to return a table that with the break down. I'm a bit lost as how to write this sql... thanks ID date ACCTN trxType Price QTY 1 12/1/2001 VCN b 2.5 100...
  3. huong30

    FIFO transactions result

    Hi SqlSister, ID       date           ACCTN   trxType Price   QTY 1 12/1/2001 VCN b 2.5 100 2 12/2/2001 VCN b 3 100 3 12/3/2001 VCN b 3.5 75 4 12/3/2001 VCN b...
  4. huong30

    FIFO transactions result

    Hi all, I have the following: ID TRXDATE ACCT TRXTYPE PRICE QTY 1 12/1/2001 VCN b 2.5 100 2 12/2/2001 VCN b 3 100 3 12/3/2001 VCN b 3.5 75 4 12/3/2001 VCN b 3.2 100 5 12/6/2001 VCN s 6.5 100 6 12/7/2001 VCN b 6.9 100 7 12/15/2001 VCN s 7 50 8 12/16/2001 VCN s 8 50 9 12/16/2001 VCN s 9 150...

Part and Inventory Search

Back
Top