shagil.a.gopinath (5/31/2016)

---

Dear Team,

My requirement is to calculate the failure time, I just want to know the difference in hours where the status is 'I' and it shouldnt calculate if status...

ganapathy.arvindan (5/30/2016)

---

IT IS WORKING FINE BUT IN THE OUTPUT I ALSO NEED THE DETAILS OF D1..D31 SHIFTS AND FINALLY THE WORKING DAYS

LIKE THIS

empid D1 ...

ganapathy.arvindan (5/30/2016)

---

Yes your right, it is a pivot table, please let me know whether it is possible to calculate working days in pivot table itself, please help me in solving...

ganapathy.arvindan (5/30/2016)

---

Yes your right, it is a pivot table, please let me know whether it is possible to calculate working days in pivot table itself, please help me in solving...

I am wondering ....based on some of your previous threads.....are these "tables" not real tables but pivoted views of your raw data?

In my opinion, to get the results that you...

please read this

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

"images" dont help us replicate your data

ok....care to explain what you mean by "Employee tableformat"

I am sorry, but I cannot help you.

for what its worth here is some code to set up the data in SSMS....based on on your previous posts

USE [tempdb]

GO

IF OBJECT_ID('tempdb..dayshift') IS...

itsyourssankalpa (5/29/2016)

---

This is what I did.

I am sure there is more efficient way to do this though.

if object_id ('tempdb..#Temp') is not null

drop table #temp

if object_id ('tempdb..#Temp1') is not null

drop table...

ganapathy.arvindan (5/29/2016)

---

Another table Table_shift

consider an employee is in the following shift types

D1 to D7 in Dayshift D9 to D13 NightShiftIH D16 to D20 Day...

itsyourssankalpa (5/29/2016)

---

That works. I used cross apply and then created two new temp table that didn't have time in the resulting table from cross apply, and joined those two for...

possible guess on what you expect...........is this right or wrong?

+---------------------+

¦ pointfrom ¦ pointto ¦

¦-----------+---------¦

¦ 1 ¦ 6 ...

well this thread is now over three months old......and looking back thro it, you have been given various suggestions.....do any of them work for you?,

If not...

http://www.sqlservercentral.com/articles/books/94937/

this is the second edition

try reading thro...