Home Forums SQL Server 2005 T-SQL (SS2K5) Help with query to find free time in a patient's schedule RE: Help with query to find free time in a patient's schedule

  • July 8, 2014 at 5:11 pm

    #1727917

    Thanks much Lowell.

    I thought about that on my way home. The TimeFromTo was from a view that cast the times as varchar and concatenated to a single string. Here is the actual data:

    PtIDApptDateApptDateTimeFromTimeToActivity

    14247/7/2014 0:0012/30/1899 9:00:00 AM12/30/1899 10:00:00 AMOpening Group

    14247/7/2014 0:0012/30/1899 10:00:00 AM12/30/1899 11:00:00 AM1:1 ST Jerilyn

    14247/7/2014 0:0012/30/1899 11:00:00 AM12/30/1899 12:00:00 PMConditioning Group

    14247/7/2014 0:0012/30/1899 1:00:00 PM12/30/1899 2:00:00 PMMenu Planning Group

    14247/7/2014 0:0012/30/1899 3:00:00 PM12/30/1899 4:00:00 PMLife 101 Group

    14247/7/2014 0:0012/30/1899 4:15:00 PM12/30/1899 4:45:00 PMMedical Appt

    14247/7/2014 0:0012/30/1899 5:00:00 PM12/30/1899 5:15:00 PMLaundry Day

    Chris