Hi,
in my example on sqlfiddle, it returns Operator 3. I cant find a way to expand my query to return SD 5 and Lobby 4
any idea?
thanks
Hi,
in my example on sqlfiddle, it returns Operator 3. I cant find a way to expand my query to return SD 5 and Lobby 4
any idea?
thanks
how to create columns?
EOIVR - SB_Internal_LN - 2 - Lobby
EOIVR - SB_Internal_LN - 3 - Operator
EOIVR - SB_Internal_LN - 1 - SD
select
Convert(date,I3TimeStampGMT) as 'Dates',
(select cLevelName) as 'Options Name',
count(I3TimeStampGMT) as 'Option Press'
from IVRInterval
where
I3TimeStampGMT between '2017-10-04 00:00:00' and '2017-10-11 23:59:59'
and cLevelName like '%%EOIVR - SB_Internal_LN -%%'
and nLevel = '5'
and not cExitPath = '*'
group by cLevelName, Convert(date,I3TimeStampGMT)