Looking for some help with a query. Can i get some help with a query that will provide the MaxNumberLoggedOnAgentsToHalf results for a specific time period that combines multiple PG's into one output? The query i'm running now will only provide per peripheral but i need these combined and not individual outputs. I've tried specifying the PeripheralID and using UNION but that just results in providing the results in separate outputs and not combined. For example so the results of half hour add PG1, PG2, PG3 etc into total max agents logged in for that half.
SELECT DbDateTime,MaxNumberLoggedOnAgentsToHalf FROM dbo.Peripheral_Half_Hour where DateTime > '11/01/2018' and DateTime < '11/30/2018' and PeripheralID like '%'
Solved! Go to Solution.