 |
最新即時行情 |
| 日期 |
買高 |
前買高 |
買漲跌 |
買幅(%) |
賣低 |
前賣低 |
賣漲跌 |
賣幅(%) |
SELECT Com_Information.cmpName, Quo.* FROM (SELECT ISNULL(buy.日期, sell.日期) AS 日期, ISNULL(buy.Hot, sell.Hot) AS Hot, ISNULL(buy.cmpNo, sell.cmpNo) AS cmpNo, buy.買高, buy.前買高, ROUND(buy.買漲跌,2) AS 買漲跌, ROUND(buy.買幅,2) AS 買幅, sell.賣低, sell.前賣低, ROUND(sell.賣漲跌, 2) AS 賣漲跌, ROUND(sell.賣幅, 2) AS 賣幅 FROM (SELECT D_DAY.*, P_DAY.前買高, CONVERT(real, D_DAY.買高) - CONVERT(real, P_DAY.前買高) AS 買漲跌, (CONVERT(real, D_DAY.買高) - CONVERT(real, P_DAY.前買高)) / CONVERT(real, P_DAY.前買高) * 100 AS 買幅 FROM (SELECT 日期, cmpNo, 買高, Hot FROM Stock_Quotation WHERE (ISNUMERIC(買高) = 1) AND (日期 = '2025/7/28')) D_DAY LEFT OUTER JOIN (SELECT 日期, cmpNo, 買高 AS 前買高 FROM Stock_Quotation WHERE (ISNUMERIC(買高) = 1) AND (買高 > '0.00') AND (日期 = '2025/7/25')) P_DAY ON D_DAY.cmpNo = P_DAY.cmpNo) buy FULL OUTER JOIN (SELECT D_DAY2.*, P_DAY2.前賣低, CONVERT(real, D_DAY2.賣低) - CONVERT(real, P_DAY2.前賣低) AS 賣漲跌, (CONVERT(real, D_DAY2.賣低) - CONVERT(real, P_DAY2.前賣低)) / CONVERT(real, P_DAY2.前賣低) * 100 AS 賣幅 FROM (SELECT 日期, cmpNo, 賣低, Hot FROM Stock_Quotation WHERE (ISNUMERIC(賣低) = 1) AND (日期 = '2025/7/28')) D_DAY2 LEFT OUTER JOIN (SELECT 日期, cmpNo, 賣低 AS 前賣低 FROM Stock_Quotation WHERE (ISNUMERIC(賣低) = 1) AND (賣低 > '0.00') AND (日期 = '2025/7/25')) P_DAY2 ON D_DAY2.cmpNo = P_DAY2.cmpNo) sell ON buy.cmpNo = sell.cmpNo) Quo INNER JOIN Com_Information ON Quo.cmpNo COLLATE Chinese_Taiwan_Stroke_CI_AS = Com_Information.cmpNo WHERE Com_Information.cmpId = '7353'
多重步驟 OLE DB 操作發生錯誤。請檢查每一個可用的 OLE DB 狀態值。尚未完成任何操作。 | |
