Since there is no datatype DATE and TIME, I assume Date and TIMEs are in Varchar.declare @workhourperday intset @workhourperday = 8select p.salary, em.lname, em.fname, em.mname, case when sum(datediff(ss,datelogin+' '+timein, datelogin+' '+timeout))/(3600*@workhourperday) <> (select workingdays from working_day) THEN salary/(sum(datediff(ss,datelogin+' '+timein, datelogin+' '+timeout))/(3600*@workhourperday)) else salary/(select workingdays from working_day) end as salary_per_dayFROMDTR d inner join emp_mas emon d.empid = em.empidinner join emp_det edon em.empid = ed.empidinner join position pon p.posid = ed.empidWHEREdatepart(month, datelogin) = 6 and datepart(year, datelogin) = datepart(year, getdate())