SQLTeam.com | Weblogs | Forums

Count the number of rows for different row


#1

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


#2

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)