SELECT     CAST(CAST(t1.дата AS datetime) AS int) AS дата_для_сортировки, CONVERT(varchar( 5 ), t1.дата,  104 ) AS дата, t1.Status, t1.UserName, Catalog.Name, 
                      Catalog.Description, t1.k
FROM         (SELECT     CAST(TimeStart AS date) AS дата, Status, UserName, ReportID, COUNT(*) AS k
                       FROM          ExecutionLog
                       WHERE      (TimeStart >= @начало_периода) AND (TimeStart < DATEADD(day,  1 , @конец_периода))
                       GROUP BY CAST(TimeStart AS date), Status, UserName, ReportID) AS t1 INNER JOIN
                      Catalog ON t1.ReportID = Catalog.ItemID