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

    SQL to return unique results based on 2 fields

    I will be calling the SQL from inside an asp page. Any suggestions of how I could combine SQL and asp would help.
  2. eakinpeter

    SQL to return unique results based on 2 fields

    I still haven't managed to solve this yet Any other suggestions?
  3. eakinpeter

    SQL to return unique results based on 2 fields

    Thanks for the responses but the problems are: PHV - this solution will return the same image if it has the same tags and I would like different images IanWaterman - this solution will return the same tag more than once as each photo can have multiple tags
  4. eakinpeter

    SQL to return unique results based on 2 fields

    Hi all Problem is I want to return unique results based on 2 fields: I have a table tags_photos which is a join table and has 2 fields: tagId and PhotoId. I want to create a page which has a list of all tags and a thumbnail against each tag. However I only want to show each tag once and I...
  5. eakinpeter

    Trying to keep same position in 2 tokenized strings

    Hi all I have 2 strings string1 and string2 which are both comma delimted. What I wasnt to do is tokenize xsl helper on both strings and then cycle round them. i.e. I want to do something with the 1st value in both lists then the 2nd value in both lists and so on. ultimately I want something...
  6. eakinpeter

    Urgent help needed fo counts and sums between 2 tables

    Yes that's it guys, absolute genious's I tell ya. Thanks a lot, i really appreciate it. Peter
  7. eakinpeter

    Urgent help needed fo counts and sums between 2 tables

    I would really appreciate any help with guys guys as I'm nearing a deadline and I need this donw before I can do other stuff. I have 2 tables which show the details of files on 3 different file servers, the tables are laid out below with an example from each: file table FILE_NAME...

Part and Inventory Search

Back
Top