Eugene Elutin (5/3/2012)

---

Based on data provided there are no discrepancies in a query results:

Employee NameMonthYearWorking HoursActual HoursHrs_DiffMin_DiffS Cat2 HoursM Cat2 HoursB Cat2 HoursR Cat2 Hours

VishalMay201228:00:0029:11:001110:00:000:00:000:00:000:00:00

Working Hours are correct: 28:00:00...

Eugene Elutin (5/3/2012)

---

Based on data provided there are no discrepancies in a query results:

Employee NameMonthYearWorking HoursActual HoursHrs_DiffMin_DiffS Cat2 HoursM Cat2 HoursB Cat2 HoursR Cat2 Hours

VishalMay201228:00:0029:11:001110:00:000:00:000:00:000:00:00

Working Hours are correct: 28:00:00...

Really Sorry Eugene, actually...

This is the example from SQL:

Bhasin, VishalMay2012161:00:0015:12:09-145-470:00:000:00:0014:00:000:00:00

Eugene Elutin (5/3/2012)

---

Your requirements are complicated enough, coding without style adds up...

Do you remember my joke about noodles? So, code-noodles good for lunch, but it's hard to work with.

First what...

Eugene Elutin (5/3/2012)

---

Your requirements are complicated enough, coding without style adds up...

Do you remember my joke about noodles? So, code-noodles good for lunch, but it's hard to work with.

First what...

pwalter83 (5/3/2012)

---

Eugene Elutin (5/3/2012)

---

Could you please specify what results should look like exactly from sample data you posted.

I cannot see where you are trying to group by category2_id in your...

Eugene Elutin (5/3/2012)

---

Could you please specify what results should look like exactly from sample data you posted.

I cannot see where you are trying to group by category2_id in your query...

Hi Eugene,

I am trying to resolve this last requirement with the query. The problem I am facing now...

Thanks a ton once again for saving my job !!! I have completed the report which I has...

Eugene Elutin (5/1/2012)

---

....

I suggested the same thing you mentioned to the person who created these tables. However, I got the reply that this was out of question and I have...

Eugene Elutin (5/1/2012)

---

You would greatly benefit if you could normalise your Staff table.

I would suggest to get MonHours, TueHours etc. out of this table and place it into dedicated StaffWorkHours...

Eugene Elutin (5/1/2012)

---

Paul, let start from making your query a bit more readable.

1. You can use DATENAME function instead of converting month number to string.

2. You don't need check if...

yes,please find the DDL and sample data below:

Staff- DDL

--------------------------

CREATE...

Eugene Elutin (4/27/2012)

---

... was able to achieve this with code:

convert(int,((sum(datepart(hour,Timenetin) * 3600) + sum(datepart(hour,cat2_hours) * 3600) + sum(datepart(minute,Timenetin) * 60) + sum(datepart(minute,cat2_hours) * 60) + sum(datepart(second,Timenetin) *...