Superbly worked

Just one small change the QTR query will have QQ in datepart function. Right?

SELECT

empid,

[Week] = (SELECT SUM(workedhours) FROM EmployeeDetails w WHERE w.empid = e.empid and DATEPART(WW, workdate) = DATEPART(WW, GETDATE())),

[Month] = (SELECT SUM(workedhours) FROM EmployeeDetails w WHERE w.empid = e.empid and DATEPART(mm, workdate) = DATEPART(MM, GETDATE())),

[Qtr] = (SELECT SUM(workedhours) FROM EmployeeDetails w WHERE w.empid = e.empid and DATEPART(QQ, workdate) = DATEPART(QUARTER, GETDATE()))

FROM EmployeeDetails e