Thank you

Thank you very much for your help Thom

Assume that there is other xyz varchar column instead of date column. My requirement is: I should display only one agentid tag and agentdatawork tag for each agent

Hi Thom,

Please ignore sorting.

Thank you

USE tempdb
CREATE TABLE dbo.Agent(AgentID varchar(5),code varchar(20),date varchar(20),reason varchar(10))
insert into dbo.Agent
select '001','Not Ready','1/1/2018 9:00 am', 'break' union
select '001','Available', '1/1/2018 9:05 am', 'Ready' union
select '001','Not...