Buen dia mi problema es el siguiente tengo la siguiente sentencia en SQL Server 2008
SELECT TOP 10 dbo.tb_users.User_Name, COUNT(dbo.tb_packexcep.Error_Number) AS TOTAL, Convert(Char(10), DateStamp , 101) as Fecha
FROM dbo.tb_packexcep INNER JOIN
dbo.tb_users ON dbo.tb_packexcep.User_id = dbo.tb_users.User_id
WHERE Convert(Char(10), tb_packexcep.DateStamp , 101) between '07/18/2013' AND '07/21/2013'
GROUP BY dbo.tb_users.User_Name, Convert(Char(10), DateStamp , 101)
Order by TOTAL DESC, Convert(Char(10), DateStamp , 101)
Go to the complete details ...