update sls.dbo.newegg_somaster
set sodate = getdate()
from sls.dbo.newegg_somaster a
inner join sls.dbo.newegg_soTransaction b
on a.sonumber = b.sonumber
where a.sonumber = 1779881
set sodate = getdate()
from sls.dbo.newegg_somaster a
inner join sls.dbo.newegg_soTransaction b
on a.sonumber = b.sonumber
where a.sonumber = 1779881
