Posted on: 10/31/2013 12:59:41 AM | Views : 672

Hi all,
I want to count average for every month in a year. But I do not have an idea how to do it.
I can display only one column.
SELECT AVG(DATEDIFF(day, ResumeToPr.HRStaffingApprovalDate, ResumeToPr.DateJoin)) AS JAN FROM ResumeToPr INNER JOIN personnelrequisition ON ResumeToPr.PrId = personnelrequisition.PrId WHERE (ResumeToPr.DateJoin IS NOT NULL) AND (DATEPART(year, ResumeToPr.DateJoin) = '2013') AND (personnelrequisition.JobTitle = 'Jr Tech 1' OR personnelrequisition.JobTitle = 'Jr Tech 2' OR personnelrequisition.JobTitle = 'Tech 1' OR personnelrequisition.JobTitle = 'Tech 2' OR personnelrequisition.JobTitle = 'Sr Tech') AND (DATEPART(month, ResumeToPr.DateJoin) = '11') I want output like this:
---------------------------------------------------------------- ...

Go to the complete details ...