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 dencom 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: ETOMBS
  • Content: Threads
  • Order by date
  1. ETOMBS

    Pivot Table Help- need help finishing it up.

    I'm trying to develop a pivot table where the values from one row are put into separate columns on my output. My problem is not separating the vaules into columns, but rather, re-assmbling them into one record with a distinct key, because each row can have more than one selected value for the...
  2. ETOMBS

    Select the latest Timestamp by non unique record

    Im haveing a problem extracting the latest timestamp from a table where the only thing that may differentiate records is the timestamp. Name result timestamp gary busey 1 9/1/2010 14:14 gary busey 1 9/2/2010 14:14 Darth Vader 1 9/1/2010 14:14 Darth Vader 1 9/5/2010 14:14 gary busey 2...
  3. ETOMBS

    using select to update a record in the same table

    I'm trying to insert a key value into the last field in the row (new_lead.) This is based on data that we have collected over time from clients. I keep having issues getting it to work. I'm not sure how to code it at this point, based on the error 'Error Code : 1248 Every derived table must...

Part and Inventory Search

Back
Top