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. azeemkhn

    comparing and adding row data

    https://res.cloudinary.com/engineering-com/raw/upload/v1579356038/tips/sampledata.csv_lhtraf.xlsx Please guide: 1- I have to compare 'MOVINGAVERAGE' column of current row with next row until 'MOVINGAVERAGE' column of next row has greater value than previous column. 2- lets say, there are 12...
  2. azeemkhn

    COMPARING ROWS AND ADD THEM

    https://res.cloudinary.com/engineering-com/raw/upload/v1579355708/tips/sampledata.csv_ylpprz.xlsx Please guide: 1- I have to compare 'MOVINGAVERAGE' column of current row with next row until 'MOVINGAVERAGE' column of next row has greater value than previous column. 2- lets say, there are...
  3. azeemkhn

    please guide how can I get top 5 ro

    please guide how can I get top 5 rows of each item transaction. I have one table where 10 different items transactions exists with Item code, trandate and stock qty. I want to get top 5 record of each item based on transaction date.
  4. azeemkhn

    is there any function in SQL SERVER

    is there any function in SQL SERVER 2012 to calculate moving average or running moving average?? if no, please guide how moving average can be calculated ??
  5. azeemkhn

    multip rows merging in in single record.

    thanks.
  6. azeemkhn

    multip rows merging in in single record.

    https://res.cloudinary.com/engineering-com/raw/upload/v1579101309/tips/query_bkcbws.xlsx in one table, there are below two records in separate lines. I need to get result in single line. Asset code is identical in both lines, rest data different. I want to move 2nd line Trndate and Next qty...

Part and Inventory Search

Back
Top