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

    Getting Close need a Max Field can you help

    That is the point I needed different timstamps to determine the range for the Overlap. What I need to figure out is how to select the Max count...
  2. SuperSqlr

    Getting Close need a Max Field can you help

    I have this query to retun the results froma single table with six columns...They are Proc_id,anest,start_time,start_date,end_time,end_time... This is returning all procedures that overlap by setting a timestamp and InnerJoin to compare those that overlap. I am triing to return the Max...
  3. SuperSqlr

    Create range to compare procedure overlap

    So what I came up with is here, I still need to single out the MAX proc_id Overlap, like Select Max(....can't get it to work though, maybe a Order by Max Proc_id,... SELECT a.proc_id, Count (a.proc_id), a.anest FROM anest_procedures AS a, anest_procedures AS b WHERE (CAST (a.start_date || '...
  4. SuperSqlr

    ANSI Looking for Overlaps in timestamps or range

    I sort of figured it out but take a look please. I have a table and it has 6 columns. Procedure_id, Doctor, Start_date, Start_time, End_date, End_time... So what I was asking is how to alias a timestamp so I can determine the procedures that overlap. So if a procedure overlaps another it can...
  5. SuperSqlr

    Create range to compare procedure overlap

    I am using a simple database to try to figure out how to look at procedural overlaps. I have 6 columns and one is a pk Proc_id. What I am trying to figure out is this: Four of the columns are Start_time, Start_date, End_time, End_date. I have concatenated the Start_time and Start_date and...
  6. SuperSqlr

    ANSI Looking for Overlaps in timestamps or range

    I have a problem that is easy for you and way hard for me. I am triing to look for overlaps in timestamps. Basically I have concatenated a start_date and Start_time, column and I need to set a range to the End_date and End_time column. Then I will be able to look for procedures that are...

Part and Inventory Search

Back
Top