• 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