Thanks for the reply.

Its data flow of tables from one server to another in different regions.

We dont have windows login to the both the machines ....

Only one of the machines...

Thanks for the replies...

Here the issue ie like : we have two servers (UK and US), with different login names. I mean to say user accounts.

But when i run the...

I do not believe that Windows 2003 SP1 is supported any longer, so you will need to move up to SP2 should you wish to continue to receive any support...

insert @t3

select distinct SUBSTRING(Column1, 1,PATINDEX('%,%',Column1))

from @t2

while @@ROWCOUNT 0

begin

update @t2

set Column1 = STUFF(Column1, 1, PATINDEX('%,%',Column1), '')

delete @t2 where PATINDEX('%,%',Column1) = 0

insert @t3

select distinct SUBSTRING(Column1, 1,PATINDEX('%,%',Column1))

from @t2

end

---------------------------------------------------------

adding this to the functionit...

Table has indexing properly and when ran Profiler the part which is using high CPU is at TempTable :

----------------------------------------------------------------------------------------------

INSERT INTO @TempOEDetails

SELECT ...