is not contained in either an aggregate function or the GROUP BY clause

Vote count:

0

I get an error Column 'tbl_GP_EmployeeTimeSheetDetail.date' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

when I execute

select dt.employeeid ,e.name as name ,e.refcompany as supplier, dt.category as ctry, dt.dte as dt, dt.hr as hr,dt.totalHour,(select top 1 cg.name from tbl_GP_EmployeeTimeSheetMaster etm

LEFT join tbl_GP_EmployeeTimeSheetDetail etd on etm.emptimesheetmasterid = etd.emptimesheetmasterid

inner join tbl_GP_Category cg on cg.categoryid=etm.categoryid

where employeeid = dt.employeeid

order by fromdate desc) as category from

( select isnull(sum(etd.hour),0) as totalHour, etd.employeeid , etd.date as dte, etd.hour as hr, cg.name as category

  from  tbl_GP_EmployeeTimeSheetMaster etm           

inner join tbl_GP_EmployeeTimeSheetDetail etd on etm.emptimesheetmasterid=etd.emptimesheetmasterid

inner join tbl_GP_SiteMaster sm on sm.siteid=etm.siteid

inner join tbl_GP_Category cg on cg.categoryid=etm.categoryid

inner join tbl_GP_ProjectLPOMaster plm on plm.projetlpomasterid=etm.projetlpomasterid inner join tbl_GP_ProjectMaster pm on pm.projectid=plm.projectid

inner join tbl_GP_Employee em on em.employeeid=etd.employeeid

where cast (CONVERT(varchar, etm.fromdate ,101)as datetime) >= '2015-02-01' and cast (CONVERT(varchar, etm.todate ,101)as datetime)<='2015-02-12' group by em.companyid,etd.employeeid )

dt

inner join tbl_GP_Employee e on e.employeeid = dt.employeeid

asked 25 secs ago

Rijish Rajan

1

is not contained in either an aggregate function or the GROUP BY clause