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 derfloh 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. MedievalKnight

    get only one result with three different fields from same table

    This is awesome! Works like a charm. I've been breaking my head on this the whole evening. Thank you very much, Christophe
  2. MedievalKnight

    get only one result with three different fields from same table

    as an answer to your question: yes ;-)
  3. MedievalKnight

    get only one result with three different fields from same table

    Now, I have implemented it via a left outer join, selecting only those values that are not null. But, when you have 2 email adresses for instance, you'll see 2 rows comming back, and I only want the first created one. This is the query: SELECT DISTINCT a.id, a.related_id, c.email_adres...
  4. MedievalKnight

    get only one result with three different fields from same table

    I have a unique ID (int) column and a created_date (datetime) column. The last one could be used then?
  5. MedievalKnight

    get only one result with three different fields from same table

    Hi, I'm affraid the First (or last) aggregate functions do not exist in SQL server. Min and max are not correct.
  6. MedievalKnight

    get only one result with three different fields from same table

    Hi, I'm a bit stuck here. I have a table called STM_COMM and it contains following fields: id, member_id, email_addr, tel_nr, fax_nr A member can have multiple email addresses, telephone numbers and faxnumbers. so we could have something like this: id member_id email_addr tel_nr...

Part and Inventory Search

Back
Top