Hi,

Thanks for your solution, it works for me.

Can u please elaborate that what is the meaning or purpose of "COLLATE Latin1_General_BIN".

Regards,

Ankita

Initially data is displaying like this

create table events (WorkRole varchar(100),UpdateType varchar(100) , Users varchar(100),UpdateTime datetime(20) , NewValue nvarchar(max))

insert into events

select 'Admin TSL', 'Created', 'varsha', '11-05-2012 14:10', 'Work Role Name=Admin TSL,...

This is my stored procedure which brings the data through various tables. Now I want to merge the data of those columns which have same data for these columns- WorkRole,...

I have tried to open ur link from google chrome as well as ie explorer but getting same issue on both - "Webpage cannot be display".

Hi,

Thanks for ur rep.

Is this ur link - "How to post data/code on a forum to get the best help" - Jeff Moden

I had tried to open this link...