Home Forums SQL Server 2014 Development - SQL Server 2014 Compare 3 tables and calculate working days RE: Compare 3 tables and calculate working days
GA_SQL
Hall of Fame
Points: 3166
More actions
May 30, 2016 at 11:27 pm
#1882068
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 D2.............D31 working days
290 dayshift dayshift........Nightshift 22