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 IamaSherpa 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: nqaul
  • Order by date
  1. nqaul

    Removing Duplicate Data and Formating Results

    Hi, I have several queries each returning results with duplicated data, such as this: staff_id date hours duty 1 1/1/04 8-5 C 2 1/1/04 9-6 W 1 2/1/04 9-4 C 2...
    • nqaul
    • Thread
    • Replies: 0
    • Forum: MySQL
  2. nqaul

    Database Design For a Roster System

    Hi, I'm building a sub-system that will auto generate staff rosters, so far I've got the following tables: Staff (sid, Name, etc...) Roster(rid,startdate,enddate) Date(dateid,date) StaffDay(sid,rid,dateid,starttime,endtime,duty) sid,rid,dateid in the StaffDay table will be enforced as a...

Part and Inventory Search

Back
Top