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 Wanet Telecoms Ltd 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: jp777
  • Content: Threads
  • Order by date
  1. jp777

    Flattening many records into one

    I have a table as below product char(10) date datetime points integer(9) flag char(1) my requirement is to show the last (by date) 10 points (with dates) on one line, for all products example product points date points date points date (for 10) product2 points date...
  2. jp777

    SQL Hope you can help

    Hi, I have a table; product char(10) date datetime points integer(9) flag char(1) I want to read the latest (by date) 2 records for each product and add a flag to each if the points value has changed. To be honest I don't have much sql and am completely stuck Thanks for...

Part and Inventory Search

Back
Top