I've had both non-technical and technical managers and, in my experience, there are problems with both. My non-technical manager didn't understand that to make an application simple for the...

Why is the server scheduled to be rebooted weekly?

I won't say that this is the best way to do it, but I believe a simple self join on record_id with a case statement will work:

select

A.*,

B.*,

Case

When A.item...

First of all, I agree with Robert, it is a lot easier to deal with regular datetime data types than it is to deal with them in parts, but here...