02-11-2019 12:22 PM - edited 03-15-2019 06:44 AM
Hey Guys,
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 '%'
Thank you,
Kurtis
Solved! Go to Solution.
02-14-2019 04:40 AM
02-14-2019 04:40 AM
02-14-2019 06:12 AM
Thanks, that's perfect!!
02-19-2019 06:06 PM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide