《BI那点儿事》Microsoft 逻辑回归算法——预测股票的涨跌

UPDATE  FactStock
SET     [涨跌] = N'涨'
WHERE   [涨幅] > 0

UPDATE  FactStock
SET     [涨跌] = N'跌'
WHERE   [涨幅] < 0

UPDATE  FactStock
SET     [涨跌] = N'持平'
WHERE   [涨幅] = 0

SELECT  [涨跌] ,
        COUNT(*) AS Cnt
FROM    FactStock
GROUP BY [涨跌]

SELECT  *
FROM    FactStock
WHERE   [涨跌] = N'持平'

SELECT  MAX(收盘) ,
        MIN(收盘) ,
        AVG(收盘)
FROM    FactStock

UPDATE  FactStock
SET     序列 = CAST(REPLACE(CONVERT(CHAR(10), SUBSTRING([时间], 1, 10), 120), '-',
                          '') AS INT)

SELECT  *
FROM    FactStock