Declare @var varchar(1000)

Set @var=''

Select @var = @var + fruit + ',' from #temp

Select substring(@var,1,len(@var)-1)

Yes It actually worked for me now. My table has no index. First I ran the below statement in one query window

BEGIN TRAN

update dbo.Profit_Act1 with(rowlock)

--rowlock is the default...

Yes It actually worked for me now. My table has no index. First I ran the below statement in one query window

BEGIN TRAN

update dbo.Profit_Act1 with(rowlock)

--rowlock is the default...

Yes It actually worked for me now. My table has no index. First I ran the below statement in one query window

BEGIN TRAN

update dbo.Profit_Act1 with(rowlock)

--rowlock is the default...

I actually tried to run the query without adding an index and it still worked for me. There were no waiting locks. Any reason why?

thanks Dinesh but in Sql Server 2005 its easy too.. All you have to do is to use a data flow task and you are on!!