如何更新一个表的列值比较其他表条件 [英] How to update column value of one table comparing other table condition

问题描述

update Attendence set Att_UpdateBit='0'
where fk_Att_EmpCode   In (select pk_Emp_Code
                           from EmployeeMaster
                           where ((@ATReprs_Location='All') or (fk_Emp_LocCode=@ATReprs_Location)) and
                             ((@ATReprs_Catagory='All')or (fk_Emp_CatCode=@ATReprs_Catagory)) and
                             ((@ATReprs_Department='All') or (fk_Emp_DepCode=@ATReprs_Department)))and
                                Att_Date>=@ATreprs_Fromdate and Att_Date<=@ATreprs_Todate

    



 here i am using store procedure and i am paasing parameter  and i am updating one table column from comparing other table condition with condition .Its Working  fast only 50 employe ,,but if i update using "excel upload It will tak eso much time after it show "sql query time out " please can any one help me

推荐答案

请按照以下代码：

Follow the below code:

update atten set atten.Att_UpdateBit='0' from Attendence atten
 join EmployeeMaster Emp on (Emp.@ATReprs_Location=atten.fk_Emp_LocCode or Emp.@ATReprs_Location='All')  and
 (atten.fk_Emp_CatCode=Emp.@ATReprs_Catagory  or Emp.@ATReprs_Catagory='All')
 and(atten.fk_Emp_DepCode=Emp.@ATReprs_Department or  Emp.@ATReprs_Department='All')
 where  Att_Date>'some date'

这篇关于如何更新一个表的列值比较其他表条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！