Nice Problem!!

To get you started, i've worked out the SQL for the first shift, you can do the rest yourself 😛

It looks like its been butchered, however I can't think...

To do what you need you will have to self join on the #avetime table:

select stime.phoneuser, stime.origdate as call_start, etime.origdate as call_end

from #avetime stime

inner join avetime etime

...

Unfortunately i'm inbetween jobs at the moment . No database at home except for northwind and pubs and i wanted something bigger to play...

thanks, I wanted something bigger though

Very strange

Try running this:

select name from master..sysdatabases

and see how long it takes

Great article! And a situation which I think most DBA's have had experience with, even if it just involves messing up a test database and inconviencing a handfull of people for...