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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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... -
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... -
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...- SuperSqlr
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
