c1sc0m

Comments

  • This is the code I managed to create by looking at the builtin templates: SELECT TOP 10000 CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),101) AS SummaryMonth, Nodes.Department AS Department, Nodes.City AS City, Nodes.NodeID AS NodeID, Interfaces.InterfaceID AS InterfaceID, Nodes.Caption AS…