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

    Replacing MS Access 'Last' function

    Hey folks, I searched through the previous threads on this subject and just have been unable to get the right combination of 'group by' and joins to get the expected results in SQL Server2K. Here is the SQL string that worked in MS Access. Can anyone offer any guidance to get this to work in...
  2. rbruder

    Different components of 1-M in single query

    Morning folks, my first post here. I'm hoping it'll be an easy one for those more experienced than I. Table 1: Parcels Parcel ID Table 2: Ownership Parcel ID Person ID OwnerStatus ('Current Owner','Current Co-Owner') Table 3: Person Person ID First Name Last Name Parcels & Ownership have a...

Part and Inventory Search

Back
Top