Thanks for the replies i found the solution....

this is the sample schema and query

create table #Temp

(

issueid int not null,

status nvarchar(1),

ownedby nvarchar(15),

[desc] nvarchar(max)

)

insert into #Temp values(1,'A','1','xyz')

insert into #Temp values(2,'A','1','xyz')

insert into #Temp values(41,'A','43','xyz')

insert into #Temp values(56,'A','34','xyz')

insert into #Temp...