multi update link server problem

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Julian Kuiters SSCertifiable Points: 6585 More actions · Answer 1

Errr. that's very not right. Perhaps you want something like:

UPDATE TableA

SET val1 = valueX,

val2= valueY,

val3= valueZ

FROM TableA

JOIN (SELECT *

FROM OPENQUERY(linkedserver, 'SELECT valueX, valueY, valueZ FROM picomp WHERE time = date(''*'') AND tag = ''rt1mp001'' ')

AS TableB

ON TableA.somecolumn = TableB.somecolumn

midan1 SSCertifiable Points: 5100 More actions · Answer 2

i is not ok

my problem is this

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

--1----v-1-----------

UPDATE [pitable].[dbo].[allpi]

SET val1 = (SELECT *

FROM OPENQUERY(pcnh, 'SELECT value as ro1 FROM picomp WHERE time = date(''*'') AND tag = ''rt1mp001''

'))

--2----v-2-------

UPDATE [pitable].[dbo].[allpi]

SET val2 = (SELECT *

FROM OPENQUERY(pcnh, 'SELECT value as ro2 FROM picomp WHERE time = date(''*'') AND tag = ''rt2mp001''

'))

--3-------v-3-------

UPDATE [pitable].[dbo].[allpi]

SET val3 =(SELECT *

FROM OPENQUERY(pcnh, 'SELECT value as ro3 FROM picomp WHERE time = date(''*'') AND tag = ''rt3mp001''

'))

---------------------- and more 30 updates

i need one connection from the link server

thnks ilan