本區塊出現錯誤,請洽管理員
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. SELECT s.ICODE FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY i.AddDate DESC ) as rn ,i.ICODE FROM ITEM AS i INNER JOIN ITEM1 as i1 on i.ICODE = i1.ICODE1 INNER JOIN ITEM4 as i4 on i.ICODE = i4.ICODE4 INNER JOIN ITYP_ALL AS ita ON ita.ITCO1 = i.ITCOD AND ita.ITCO2 = i1.ITCO2 AND ita.ITCO3 = i1.ITCO3 AND ita.ITCO4 = i1.ITCO4 AND ita.ITCO5 = i1.ITCO5 WHERE i1.INSTOP = 0 AND i1.STOPSALE = 0 AND i1.ISTOP = 0 AND i4.CH62 = 1 AND i4.CH63 = 0 AND i4.WebCategoryBrow = 1 AND i4.CH67 = 0 AND i.ICODE IN (SELECT ii.ICODE FROM ITYP_ITEM AS ii WHERE ii.ITCO1 = @ITCOD) AND ita.Visible = 1 AND @Date BETWEEN i4.T11_0 AND CASE WHEN i4.T11_1 = '' THEN '999.99.99' ELSE i4.T11_1 END ) as s WHERE s.rn BETWEEN @RowStart AND @RowEnd ORDER BY s.rn