hello all,i have wriiten a query with the help pivot table upto that result is coming fine here is the query : SELECT P.Name,p.EmpID,P.BranchID,[54] AS Active, [55] AS InActive,P.Ser,P.Cond,[56] AS Deleted, [57] AS SettledFROM(Select E.EmpID,E.FirstName+' '+E.LastName as Name,E.BranchID,B.Cust_ID,LAc.ProfileStatusID,Count(B.IsSerious) as ser,Count(B.IsConfidential) as Condfrom Emp_Details E join Cust_BasicInfo B on E.EmpID=B.ProfileOwnerEmpID join Cust_Login LAc on LAc.Cust_ID=B.Cust_ID group by B.IsSerious,B.IsConfidential,E.EmpID,E.FirstName,E.LastName,E.BranchID,LAc.ProfileStatusID,B.Cust_ID) sPIVOT (COUNT(Cust_ID) FOR ProfileStatusID IN ([54],[55],[56],[57]))P
the colored one i am facing trouble in result set : Name EmpID BranchID Active InActive Ser Cond Deleted SettledChaitanya Teja 2 7 1 1 1 1 2 1VBhaskaraReddy Kovvuri 3 7 4 2 1 1 1 2
but here i need to get full count of column ser and cond but it just showing 1 and 1 . actually for empid 2 and 3 having count of ser and cond around 4 and 6 but it is showing just 1 count....how to get full count suggest meP.V.P.MOhan