Search results for query: *

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

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

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

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

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

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