Database

Mdallal84 wrote:

dataMember to the columnName.

select z.*, (z.Bassalary/(z.days*z.Whrs)) as onehour
from (
   select a.empid, b.empName, c.Whrs, c.srg,
      case when srg=0 then @Outsunday else @Insunday end as days,
      c.Bassalary,
      sum(AppWHours) as TWhrs,Sum(AppOtHours) as TOThrs
   from tblMonthHourDetails a, tblemployeemaster b, tblsalarydetails c
   where a.empid=b.empid
   and a.empid=c.empid
   and b.projectid=@projectid
   and datepart(mm,[SDate])=@months
   and datepart(yy,[SDate])=@Years
   group by a.empid, b.empName, c.Whrs, c.srg, c.Bassalary
) z
order by z.empid