SELECT *,CASE WHEN cmpStartDate > '' THEN CASE WHEN CONVERT(int, REPLACE(LEFT(cmpStartDate, CHARINDEX('/', cmpStartDate)), '/', '')) < 1000 THEN CONVERT(nvarchar, CONVERT(int, REPLACE(LEFT(cmpStartDate, CHARINDEX('/', cmpStartDate)), '/', '')) + 1911) + substring(cmpStartDate, CHARINDEX('/', cmpStartDate), 20) ELSE cmpStartDate END ELSE NULL END AS StartDate FROM (SELECT Com_Information.cmpId, Com_Information.cmpNo, Com_Information.cmpName, Com_Information.cmpFullName, Com_Information.cmpOpenType, Com_Information.cmpType, Com_Information.stkNo, Com_Information.cmpStartDate, S.D, S.H FROM Com_Information LEFT OUTER JOIN (SELECT cmpNo, MAX(日期) AS D, MAX(Hot) AS H FROM Stock_Quotation GROUP BY cmpNo) S ON Com_Information.cmpNo = S.cmpNo WHERE (Com_Information.cmpOpenType > 3) AND (Com_Information.cmpType LIKE '%')) db ORDER BY D DESC, H DESC
資源集區 'default' 中的系統記憶體不足，無法執行此查詢。