Home Forums SQL Server 2008 SQL Server 2008 - General elegant strategies for complex update statements? RE: elegant strategies for complex update statements?
sqlguy-736318
Hall of Fame
Points: 3859
More actions
April 4, 2013 at 8:25 pm
#1603786
What I'm suggesting is that table #a would have 2 rows with the same company. For example:
'Microsoft', 'Seattle'
'Microsoft', 'Portland'
In this scenario, row #1 would get updated but row #2 would not.