隱藏輸入框使用each

$("#mtable").find("input,select").each(function(){
  switch(this.name)
  {
     case "ReportItem":
     case "ReportName":
        hideDroplist($(this),"black");
        break;
     case "DataDateS":
     case "DataDateE":
        hideInput($(this),"black");
        break;
  }
}

刪除Table中重覆資料

SELECT  *

FROM   [TableName]

WHERE (DATEDIFF(day, [StartDate], CONVERT(DATETIME, @sDate, 102)) >= 0

AND DATEDIFF(day, [EndDate], CONVERT(DATETIME, @sDate, 102)) <= 0 OR

DATEDIFF(day, [EndDate], CONVERT(DATETIME, @eDate, 102)) <= 0 

AND DATEDIFF(day, [StartDate], CONVERT(DATETIME, @eDate, 102)) >= 0 OR

 DATEDIFF(day, [StartDate], CONVERT(DATETIME, @sDate, 102)) <= 0 

AND DATEDIFF(day, [EndDate], CONVERT(DATETIME, @eDate, 102)) >= 0)