Thank you so much..working fine for dayshift...let me know the changes for Nightshift

DECLARE @businessDay date;

--- Recursive common table expression:

WITH rcte ([date], nextBusinessDay)

AS (

...

Getting no idea about this...please help me

In previous i am working with shift calculations based on working days of the individual month..here i am trying to calculate every month working days..since the company declares holiday list...

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 ...

it is a realtime scenario..it is payroll stuff to calculate SP to calculate working days based on the shift.. please help me in this

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 this

CREATE TABLE EMPLOYEE(empid1 INT,[D1] VARCHAR(25),[d2] VARCHAR(25),d3 VARCHAR(25),d4 VARCHAR(25),d5 VARCHAR(25),d6 VARCHAR(25),d7 VARCHAR(25),d8 VARCHAR(25),d9 VARCHAR(25),d10 VARCHAR(25),d11 VARCHAR(25),d12 VARCHAR(25),d13 VARCHAR(25),d14 VARCHAR(25),d15 VARCHAR(25),d16 VARCHAR(25),d17 VARCHAR(25),d18 VARCHAR(25),d19 VARCHAR(25),d20 VARCHAR(25),d21 VARCHAR(25),d22 VARCHAR(25),d23 VARCHAR(25),d24 VARCHAR(25),d25 VARCHAR(25),d26 VARCHAR(25),d27...

trying to add a image on employee table format but not able to

Employee tableformat

Expected results are consider

employee is in dayshift from d1 to d7 refer to dayshift table

d1 - Holiday(HL) d2 to d7- working days

d8 - Weekoff

employee is in...

0 Points

4 Posts

Compare 3 tables and calculate working days

May 24, 2016 03:20 AM|LINK

Dayshift

D1 D2 D3 D4 D5 D6 D7 D8 D9 D10 D11 D12 D13 D14 D15 D16 D17 D18...

Code is not clear here..mostly the output sample is not in clear format

THanks a lot..it is working...

Sir..Please sir..That is different requirement this one is different..sorry for bothering you