Thanks, I was trying to write it with update @PatientEpisodes because that's the name of the table I wanted to write the data into. It all seems very obvious when...

This should point you in the right direction:

select e.*, datediff(minute,

case

when convert(time,e.Start_Time) < '09:00'

then convert(time,'09:00:00')

else convert(time,e.Start_Time)

end,

case

when convert(time,e.End_Time) > '21:00'

then convert(time,'21:00:00')

else convert(time,e.End_Time)

end

) as mins

from @Evts e

You might...

SQL Server is just used to store the data (and query it), so you'll probably still need Access to provide front-end screens for niceties like data entry and reporting. The...