Hello,

Can anyone give me some advice on how to create a timeline in sql?

I work in the nhs and I am trying to create a timeline of clinician's activities. Ideally it will show each minute between the two dates as a row and then count whether the clinican was working that minute (based on the consultation start and end dates).

So it would be between the @fromdate and the @todate, eg/ 18:00 to 18:02

and would result something like:

Time | With Patient
18:00 | 1
18:01 | 1
18:02 | 0

Is this possible? Any help would be greatly appreciated.

Thanks

does this need to be solely in MySQL, or can you do some of the processing in another (frotn end tool/app language)

you may be able to generate the non patient time by JOINing to another table whihc has 0..59 in it and JOIN using the minute of the form/todates