Just remember Bryan - henceforth if tanking up on caffeine doesn't do the trick - SSC/remi (used interchangeably here) always will!

Erik - something I've been meaning to tell you - there was once a post called "My favourite SSCer"...and who one would vote for if they had to pick a...

hi remi...definitely can't think as fast as you...but as for "type faster"...you're typing too fast these days...noticed a slip-up this morning in one...

Erik - I don't think you need to focus too much on it right now...usually (eg if you're creating a table and you're not...

...really must learn to type faster...maybe we should all take lessons from remi...

since I don't see the ddls of the 2 tables I'm just guessing here...but hopefully you can tweak this and get it working....

Select A.File_ID,

...

aah - you need a "group by"...thought you did want only one row...give me some time (unless someone else gets to this first)...will be back!

Bryan...as they say...the proof of the pudding is in the eating....

have you tried .....

Select top 1 File_ID,

...

the only advice my book has to offer is to "play" with OPENQUERY AND OPENROWSET...

My suggestion would be to shoot an email/pm to noeld - there is NOTHING that he...

This just in from my SQL bible...

"Some activities cannot be executed via a linked server arrangement - these include:

DDL Statements(CREATE, DROP, ALTER) or anything that implies any one of these...

ok - these 3 updates should do it...(in the earlier post I got mixed up betw. PLLF & PLPN - I think I have it correctly now...

update [ins-p-ap].[dbo].[t_index]

set k_126 =...

Here's an example of what I meant about doing this without the cursor....the first update would be something like this:

update [ins-p-ap].[dbo].[t_index]

set k_126 = v_polno,

k_124 = v_rmno,

k_125 = v_rmname,

k_127...

Victor - I just ran your script through the Query Analyzer parser and made a few changes..removed "Go" - "The current osql utility works as if there is an implied...

My 2 cents...

There is seldom too great a divide between job description and salary....a data-entry clerk will not be offered a king's ransom......anymore than a qualified dba with several years'...

Yes - it does appear that SQL Server doesn't like any interference with its optimizer plans (at least for views)...

however, everything I've read...