1000+ line coding..lot of tables used in that sp
shiftscheduler sample
Emp_CodeShiftShiftTypeFromDateEndDate
3039242013-10-07 00:00:00.0002013-10-15 00:00:00.000
sample output expected
empidd1d1effd2d2effd3d3effd4 d4effd5 d5effd6 .... d29d29eff d30d305eff d31d31eff Totaleff workingdaysAverage
490DAYSHIFT80DAYSHIFT81DAYSHIFT83DAYSHIFT85DAYSHIFT90DAYSHIFT ....... DAYSHIFT85DAYSHIFT90DAYSHIFT911050Totaleff/workingdays
Workingdays column comes from the totalworkingdays column in our code, please help me