update T_UserInfo set Result='0',Remarks=B.Remarks from UserInfo A WITH(NOLOCK),T_DianHuaYingXiao B WITH(NOLOCK) where A.Result='8' and B.ZuoXi='"+pZuoXi+"' and B.Flag_Done!='1' and (B.Flag_TongYi='1' or B.Flag_TongYi='4') and A.Mobile=B.Mobile
update T_UserInfo set Result='0',Remarks=B.Remarks from UserInfo A WITH(NOLOCK),T_DianHuaYingXiao B WITH(NOLOCK) where A.Result='8' and B.ZuoXi='"+pZuoXi+"' and B.Flag_Done!='1' and (B.Flag_TongYi='1' or B.Flag_TongYi='4') and A.Mobile=B.Mobile