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

    SQL 2008 Alias Table - Left Join - Not getting Unique record

    What puzzles me is that there is only one record per entity with a #71 and only one with a 74 - to me the MAX function is redundant - there is nothing to compare to, but it's working and I will just take it as it is :-) I am going to use this last method though instead of mine because I have a...
  2. mwarner1

    SQL 2008 Alias Table - Left Join - Not getting Unique record

    Yes yes and yes to your comment [ "If this works, and you would like me to explain, just let me know. Also, if you are interested, I can show you a another method for returning the same data with less joins, which will perform better. "]
  3. mwarner1

    SQL 2008 Alias Table - Left Join - Not getting Unique record

    Wow - it worked! Thank you so much :-) I never would have thought to do that though. Is this a change in the way the data is handled in 2008 as opposed to 2005? Why do I need a Max now when I didn't before? Either way - thanks again!

Part and Inventory Search

Back
Top