" delete from Membership.ExcelUser where [UsernameExist]!=1 and BranchId=1Update membership.[user] SET [FirstName] = Membership.ExcelUser.[FirstName] FROM membership.[user] inner join Membership.ExcelUser on Membership.ExcelUser.Username = membership.[user].Username inner join Membership.UserBranch on Membership.UserBranch.UserId = membership.[user].UserId and Membership.UserBranch.BranchId = 1 where Membership.ExcelUser.BranchId = 1 update Language.Translation set Language.Translation.Value=el.FirstName from Membership.[User] u inner join Membership.ExcelUser el on u.Username = el.Username inner join membership.UserBranch ub on u.userid = ub.Userid where ub.BranchId=1 and el.BranchId=1 And Language.Translation.ResourceId =u.ResourceId and Language.Translation.LanguageId=1 and Language.Translation.TranslateKey=1 Insert into Language.Translation SELECT 1,el.FirstName,u.ResourceId,1,GETDATE(),null from Membership.[User] u inner join Membership.ExcelUser el on u.Username = el.Username And el.FirstName is not null inner join membership.UserBranch ub on u.userid = ub.Userid where ub.BranchId=1 and el.BranchId=1 and not exists (select 1 from Language.Translation t where t.ResourceId =u.ResourceId and t.LanguageId=1 and t.TranslateKey=1) "