Hi,
Below is sample data. Would like to group data on hourly basis and based on company
declare @callcentertable table(callid int, companyname varchar(50), custid int,callcenteruser varchar(50),isFinished bit,createdtime datetime)
insert into @callcentertable values(101,'ABC Limited',500,'Max',1,'2019-07-03 08:15:05')
insert into @callcentertable values(101,'ABC Limited',501,'Max',0,'2019-07-03 08:30:18')
insert into @callcentertable values(101,'ABC Limited',502,'Max',1,'2019-07-03 09:10:05')
insert into @callcentertable values(101,'XYZ Limited',503,'Max',0,'2019-07-03 09:40:20')
select * from @callcentertable
---------Expected result -------
Time CompanyName Contacted NotContacted User
8-9 AM ABC Limited 1 1 Max
9-10 AM ABC Limited 1 0 Max
9-10 AM XYZ Limited 0 1 Max