Find the amount of time someone is available

I have a table that contains a date, a user, whether or not the user is ready (ry) or not ready (nr) with one entry per row. I need to take this data and convert it to show the amount of time per interval that the user was in ready (ry). Data is in MS SQL 2000. Store procedures and functions are not permissible. Data from the table. ![alt text][1] [1]: http://christiananderson.weebly.com/uploads/3/9/9/9/3999554/9391819_orig.png User in and out ![alt text][2] User's availability per interval [2]: http://christiananderson.weebly.com/uploads/3/9/9/9/3999554/8023554_orig.png ![alt text][3] [3]: http://christiananderson.weebly.com/uploads/3/9/9/9/3999554/2841558_orig.png

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Mar 29, 2012 at 07:12 AM

I think it might help if you gave the data in a way that can be used to formulate a solution - screenshots mean a lot of typing. Try posting DDL statements for the tables and DML statements to populate them. Also, can you share what you've got so far? Have you attempted a query yourself?

1 ·