Home Forums SQL Server 2005 T-SQL (SS2K5) Time issues RE: Time issues

  • December 16, 2013 at 8:36 am

    #1673731

    SELECT CONVERT(char(2),Times,108)+':00' AS [Times],SUM(ACD) AS [ACD],SUM(Other) AS [Other]

    FROM SampleData

    GROUP BY CONVERT(char(2),Times,108)

    ORDER BY CONVERT(char(2),Times,108) ASC

    Far away is close at hand in the images of elsewhere.
    Anon.