I try to have an open mind when it comes to learning new things. After 20+ years in IT I've needed to, learning different technologies, different companies, even different...

this is averages over a few months:

average database size was 186 GB, on Compellent SAN

average backup time (using TSQL commands, with compression) to external Drobo disk array was 20 minutes

average...

sgmunson (11/3/2016)

---

...

Honestly, it does seem as though the query is close, but lacks the rigor that would be present if the poster really understood the nature of the existing data....

The way I look at it, the Indians stood toe-to-toe with the best team in baseball for 7 games, only really having two and...

I worked at a .com company before for 3 years, and the problem I had there was that they often ran into unknown unknowns. The people building the hardware...

drew.allen (11/2/2016)

---

Given the numerous threads the OP has started on what appears to be the same exact query, I think that this task is simply too complex to be handled...

philand3 (11/2/2016)

---

hi here OT is computed from dutyhours vs hoursworked.

i am not looking t OT instead my issue is with dutyhours incorrect computation.

Checking again to see where went wrong with...

This is from another...

You could easily make the first record reflect the termination date by doing this:

SELECT p.person_id AS PersonID, j.old_job AS JobTitle, p.start_date AS StartDate, ISNULL(p.Termination_Date, DATEADD(day, -1, j.effective_date)) AS EndDate

...

if this query is only ever meant to return 1 row, then maybe instead of calculating a generic flag 'x' in the CASE statement, calculate a preference:

SELECT TOP 1 *,...

OK, wait... maybe this line is the problem:

else sum(( [minutes] /60.0) - [Dutyhours] )

should be:

else sum(( [minutes] /60.0)) - [Dutyhours]

We can't without seeing the data for person_num 00010272 which is the one you said is calculating OT wrong.

check if the user has permissions for the dbo schema, they probably need:

GRANT ALTER ON SCHEMA::dbo TO

I think people are asking for the create table statement of your erp.action and erp.action_history tables since that is what you...

I think the best way to handle this will be a self join, probably on a temp table that has just the relevant rows from the audit table, maybe something...