Just one small thing... I also have a EmployeeMaster table which has EMPID, EMP_name, DeptID in the table.

When I pass em.DeptID=1 in where clause at the end....

.

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,...

Superb!!!!!

This is Super Excellent and exactly as I expected.

I was almost on the same lines but was not able to reach the result.

Thanks For your help and Support!

Create Table If not exists

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblEMPLog]') AND type in (N'U'))

DROP TABLE [dbo].[tblEMPLog]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

IF NOT EXISTS (SELECT...