Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Update/Case query help RE: Update/Case query help
Stefan_G
SSCertifiable
Points: 6609
More actions
August 28, 2013 at 5:59 am
#1645513
No need for anything fancy.
This should work:
update Table2
set Domain = isnull((select Domain from Table1 t1 where t1.ServerName = Table2.ServerName), 'Unknown')