Why does this code only work if executed with other statements?

Question

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

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

Mark Cowne One Orange Chip Points: 26986 More actions · Answer 1

You can to do it dynamically

EXEC('

UPDATE e

SET

e.SourceColumn2 = t.ThisColumnDoesNotExist

FROM DoesNotIncludeColumn t

JOIN DestinationTable e

ON t.Column1 = e.SourceColumn1')

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

caspersql SSCrazy Points: 2276 More actions · Answer 2

SSCrazy

Points: 2276

September 20, 2013 at 9:24 am

Wow, nice one Mark, got it working now.