CREATE TABLE [dbo].[Call](
[call_id] [smallint] NULL,
[Emp_id] [smallint] NULL,
[call_status_id] [smallint] NULL
) ON [PRIMARY]
insert into call (call_id,Emp_id,Call_status_id) values (1,25,101)
insert into call (call_id,Emp_id,Call_status_id) values (2,26,102)
insert into call (call_id,Emp_id,Call_status_id) values (3,26,103)
insert into call (call_id,Emp_id,Call_status_id) values (4,28,104)
insert into call (call_id,Emp_id,Call_status_id) values (5,25,105)
select * from call
SELECT [101] , [102], [103],[104],[105]
FROM ( SELECT [call_status_id], call_id FROM call)
P PIVOT ( sum(call_id) FOR [call_status_id] IN ([101] , [102], [103],[104],[105])) AS pvt