begin transaction update v set v.domainacct = a.login from [otherdbname].dbo.ADUserList a inner join dbo.Vacation2011 v on (v.lastname = a.lastname COLLATE SQL_Latin1_General_CP1_CI_AS and v.firstname = a.firstname COLLATE SQL_Latin1_General_CP1_CI_AS) commit transaction

select v.domainacct, a.login, a.firstname afirst, v.firstname vfirst, a.lastname alast, v.lastname vlast –into ##temp from dbo.Vacation2011 v left outer join dbo.ADUserList a on (v.lastname = a.lastname COLLATE SQL_Latin1_General_CP1_CI_AS and v.firstname = a.firstname COLLATE SQL_Latin1_General_CP1_CI_AS)