|
La sentencia sql es esta:
frmClientes.qry_reporte.SQL.Text := 'select BranchName,visit.category,RegDate,categry.contents,count(visit.category) as atendidos,avg(datediff(ss,StartTime,EndTime) - (datediff(ss,StartTime,EndTime)/60)*60)) as segundos from visit,categry where visit.category=categry.category and RegDate = '' ' + dia + ' '' and DATEDIFF(ss,StartTime,EndTime)>=20 group by visit.category,visit.BranchName,visit.RegDate,categry.contents order by visit.category';
|