【文本版|topic】 高级搜索
   名人堂 帮助 论坛制度 意见反馈 | 首页 博客 周新贴 专题 求职 读书
 RSS 底部
 
社区导航: 专家门诊   网络技术   操作系统   数据库   程序设计   系统应用   考试认证   CIO及信息化   站长交流   综合交流   下载基地  51CTO产品服务 【设为首页 | 收藏本站】
51CTO技术论坛» 微软SQL Server专区 » 微软商务智能 » 线性回归计算问题(附表结构及数据)       [ 打印]  [ 订阅]  [ 收藏]  [ 推荐给朋友]   [ 本帖文本页]
 

论坛跳转:
     
标题: 线性回归计算问题(附表结构及数据)  ( 查看:471  回复:3 )   
 该主题悬赏的100无忧币已被全部领完 
 
boyi55
副版主  点击可查看详细


诚信兄弟   天秤座  
帖子 918
精华 1
无忧币 3898
积分 959
阅读权限 140
来自 (保密)
注册日期 2006-1-12
最后登录 2008-10-7 离线

[查看资料]  [发短消息]  [Blog] 
[个人主页]    QQ       
发表于:2008-6-19 11:01　 　标题：线性回归计算问题(附表结构及数据)
＜上一帖 |
我有一张表如下所示.现要计算每支股票的BATA值,即:y=bx+a中x的系数b。用到分析服务中的函数：linregslope
表说明：表中含有200条数据。其中每支股票有21条数据。按tdate为当前股票最后21个交易日的日期。stockinc和indexinc两个值可以直接做为度量值。
计算：按单支股票汇总其21条数据的集合计算每支股票当前的BATA值。
比如：600750有以下数据：
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
tdate                                          symbol       stockinc      indexinc
2008-06-06 00:00:00.000        600750        .08625282        -.00646594
2008-06-05 00:00:00.000        600750        .22375499        -.00985352
2008-06-04 00:00:00.000        600750        .00330852        -.01876741
2008-06-03 00:00:00.000        600750        .24130433        -.00323622
2008-06-02 00:00:00.000        600750        .08715060        .00400600
2008-05-30 00:00:00.000        600750        .24998949        .00847090
2008-05-29 00:00:00.000        600750        .14820694        -.02628254
2008-05-28 00:00:00.000        600750        .26922599        .02758783
2008-05-27 00:00:00.000        600750        .31118852        .00475937
2008-05-26 00:00:00.000        600750        .26796953        -.03205256
2008-05-23 00:00:00.000        600750        -.19977225        -.00982789
2008-05-22 00:00:00.000        600750        .25425417        -.01910928
2008-05-21 00:00:00.000        600750        .58146662        .01927796
2008-05-20 00:00:00.000        600750        .23486135        -.05332593
2008-05-19 00:00:00.000        600750        -.17597657        -.00561746
2008-05-16 00:00:00.000        600750        .31333906        -.00303569
2008-05-15 00:00:00.000        600750        -.17546388        -.00699005
2008-05-13 00:00:00.000        600750        .64534836        -.01372606
2008-05-12 00:00:00.000        600750        .37757485        .00667950
2008-05-09 00:00:00.000        600750        -.24105623        -.01181900
2008-05-08 00:00:00.000        600750        -1.09836369        .02678115

则：linregslope([Symbol].[Tdate].allmembers,[Measures].[Stockinc],[Measures].[Indexinc])
但我得出的结果用EXCEL计算是不对的。如果用tdate做为维度，用刚lastperiods（21，tdate）来取的话非交易日将不考虑。
我想直接用symbol来聚合。请问应该怎么做。
附表结构及数据。

CREATE TABLE [test_quote_boyi] (
        [tdate] [datetime] NULL ,--日期
        [symbol] [varchar] (20)  NULL ,--股票代码
        [stockinc] [numeric](18, 8) NULL ,--收盘价
        [indexinc] [numeric](18, 8) NULL --指数收盘价
) ON [PRIMARY]
GO

INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600750', .08625282, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600750', .22375499, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600750', .00330852, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600750', .24130433, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600750', .08715060, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600750', .24998949, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600750', .14820694, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600750', .26922599, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600750', .31118852, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600750', .26796953, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600750', -.19977225, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600750', .25425417, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600750', .58146662, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600750', .23486135, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600750', -.17597657, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/16/2008 12:00:00.000 上午', '600750', .31333906, -.00303569 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600750', -.17546388, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/13/2008 12:00:00.000 上午', '600750', .64534836, -.01372606 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600750', .37757485, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600750', -.24105623, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/08/2008 12:00:00.000 上午', '600750', -1.09836369, .02678115 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600583', .78106806, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600583', .87699662, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600583', .68733080, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600583', .89331974, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600583', .72034292, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600583', .90087964, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600583', .80808219, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600583', .89979351, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600583', .96572086, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600583', .97177942, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600583', .52221048, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600583', .98950106, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600583', 1.26411217, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600583', .89032509, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600583', .43209417, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600583', .40657437, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/14/2008 12:00:00.000 上午', '600583', .86527785, .03171022 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/13/2008 12:00:00.000 上午', '600583', 1.13038530, -.01372606 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600583', .99811514, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600583', .45799939, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/08/2008 12:00:00.000 上午', '600583', -.39963925, .02678115 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600791', -.62883616, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600791', -.46046719, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600791', -.63286376, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600791', -.42711206, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600791', -.60599658, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600791', -.42552596, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600791', -.54494024, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600791', -.41077272, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600791', -.34186420, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600791', -.40097072, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600791', -.86445309, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600791', -.39278820, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600791', -.11024067, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600791', -.46124880, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600791', -.93802152, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/16/2008 12:00:00.000 上午', '600791', -.40500523, -.00303569 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600791', -.44047715, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/14/2008 12:00:00.000 上午', '600791', .06531531, .03171022 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/13/2008 12:00:00.000 上午', '600791', .30961024, -.01372606 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600791', .14257680, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600791', -.47630985, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600106', .15713595, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600106', .25029454, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600106', .09628884, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600106', .29537156, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600106', .13936231, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600106', .27745117, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600106', .21942969, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600106', .32429889, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600106', .36931448, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600106', .37531888, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600106', -.04975516, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600106', .51121809, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600106', .76462836, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600106', .34869181, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600106', -.26286690, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/16/2008 12:00:00.000 上午', '600106', .14132066, -.00303569 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600106', -.45874647, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/14/2008 12:00:00.000 上午', '600106', -.08427010, .03171022 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600106', -.07865206, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600106', -.61373152, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/08/2008 12:00:00.000 上午', '600106', -1.43364350, .02678115 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600883', .09373727, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600883', .20233736, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600883', .00413395, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600883', .23028927, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600883', .06938266, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600883', .25461912, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600883', .08051785, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600883', .21172149, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600883', .21754362, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600883', .19574458, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600883', -.22672806, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600883', .27682849, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600883', .61616037, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600883', .30138569, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600883', -.19343840, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600883', -.18276561, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/14/2008 12:00:00.000 上午', '600883', .33875332, .03171022 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/13/2008 12:00:00.000 上午', '600883', .58998831, -.01372606 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600883', .37217309, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600883', -.13502927, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/08/2008 12:00:00.000 上午', '600883', -.96847427, .02678115 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600009', .70175426, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600009', .83543220, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600009', .64390124, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600009', .78900049, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600009', .59490874, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600009', .77601227, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600009', .66812353, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600009', .78152112, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600009', .81012557, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600009', .80075742, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600009', .35112128, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600009', .79166392, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600009', 1.05380901, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600009', .72717345, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600009', .28516635, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/16/2008 12:00:00.000 上午', '600009', .77354366, -.00303569 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600009', .24009124, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/14/2008 12:00:00.000 上午', '600009', .70242902, .03171022 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/13/2008 12:00:00.000 上午', '600009', .93593319, -.01372606 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600009', .75365623, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600009', .23033532, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600318', -.29285161, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600318', -.16835230, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600318', -.34012430, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600318', -.13524031, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600318', -.31220761, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600318', -.13936480, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600318', -.23468385, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600318', -.12818342, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600318', -.06295412, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600318', -.11778304, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600318', -.55883824, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600318', -.05444893, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600318', .28024469, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600318', -.05085028, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600318', -.46144184, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600318', -.53820404, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/14/2008 12:00:00.000 上午', '600318', -.02336135, .03171022 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/13/2008 12:00:00.000 上午', '600318', .17509990, -.01372606 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600318', -.09256346, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600318', -.65321033, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/08/2008 12:00:00.000 上午', '600318', -1.48829019, .02678115 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600159', .09539290, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600159', .18554436, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600159', -.00165838, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600159', .20302215, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600159', -.01769958, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600159', .15514324, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600159', .03298910, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600159', .10324085, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600159', .18369944, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600159', .09721936, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600159', -.40577630, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600159', .02710718, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600159', .34982162, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600159', .01208755, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600159', -.43953995, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/16/2008 12:00:00.000 上午', '600159', .04848346, -.00303569 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600159', -.44220278, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/14/2008 12:00:00.000 上午', '600159', .05022701, .03171022 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600159', .08561879, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600159', -.44676015, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/08/2008 12:00:00.000 上午', '600159', -1.30743814, .02678115 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600895', -.01005953, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600895', .13161825, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600895', -.05535683, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600895', .11822561, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600895', -.07186129, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600895', .11169592, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600895', -.01691184, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600895', .10757174, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600895', .14866959, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600895', .09812721, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600895', -.36372257, -.00982789 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/22/2008 12:00:00.000 上午', '600895', .09450693, -.01910928 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/21/2008 12:00:00.000 上午', '600895', .42250130, .01927796 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/20/2008 12:00:00.000 上午', '600895', .09963791, -.05332593 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/19/2008 12:00:00.000 上午', '600895', -.34928428, -.00561746 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/16/2008 12:00:00.000 上午', '600895', .17663230, -.00303569 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/15/2008 12:00:00.000 上午', '600895', -.30899527, -.00699005 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/14/2008 12:00:00.000 上午', '600895', .15440439, .03171022 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/13/2008 12:00:00.000 上午', '600895', .40351845, -.01372606 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/12/2008 12:00:00.000 上午', '600895', .24529328, .00667950 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/09/2008 12:00:00.000 上午', '600895', -.26050337, -.01181900 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/06/2008 12:00:00.000 上午', '600637', -.48596288, -.00646594 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/05/2008 12:00:00.000 上午', '600637', -.38428429, -.00985352 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/04/2008 12:00:00.000 上午', '600637', -.58712408, -.01876741 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/03/2008 12:00:00.000 上午', '600637', -.40446959, -.00323622 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '06/02/2008 12:00:00.000 上午', '600637', -.58929156, .00400600 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/30/2008 12:00:00.000 上午', '600637', -.41946534, .00847090 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/29/2008 12:00:00.000 上午', '600637', -.52087893, -.02628254 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/28/2008 12:00:00.000 上午', '600637', -.41222515, .02758783 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/27/2008 12:00:00.000 上午', '600637', -.34770364, .00475937 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/26/2008 12:00:00.000 上午', '600637', -.33447224, -.03205256 )
go
INSERT INTO test_quote_boyi ( tdate, symbol, stockinc, indexinc )
                 VALUES ( '05/23/2008 12:00:00.000 上午', '600637', -.77682644, -.00982789 )
go

[ 本帖最后由 boyi55 于 2008-6-19 11:13 编辑 ]

春江潮水连海平/海上明月共潮生/滟滟随波千万里/何处春江无月明！
2008-6-19 11:011楼
[ 顶部 ]
 
jiangye
副版主  点击可查看详细



十二生肖之狗   双子座   行业勋章   技术勋章   诚信兄弟  
帖子 550
精华 1
无忧币 1652
积分 559
阅读权限 140
注册日期 2006-8-23
最后登录 2008-10-7 离线

[查看资料]  [发短消息]  [Blog] 
       
发表于:2008-6-19 23:17　 ,被系统奖励 50 点无忧币
不懂金融。
关注，希望有高手！～
感觉好多重复的地方，不能循环？

2008-6-19 23:172楼
[ 顶部 ]
 
boyi55
副版主  点击可查看详细


诚信兄弟   天秤座  
帖子 918
精华 1
无忧币 3898
积分 959
阅读权限 140
来自 (保密)
注册日期 2006-1-12
最后登录 2008-10-7 离线

[查看资料]  [发短消息]  [Blog] 
[个人主页]    QQ       
发表于:2008-6-20 08:56　 ,被系统奖励 50 点无忧币


QUOTE:
感觉好多重复的地方，不能循环？
这个主要是按symbol做聚合的。可以不用到时间维度。

春江潮水连海平/海上明月共潮生/滟滟随波千万里/何处春江无月明！
2008-6-20 08:563楼
[ 顶部 ]
 
忧伤
新新人类  点击可查看详细



帖子 4
精华 0
无忧币 10
积分 4
阅读权限 20
注册日期 2008-6-28
最后登录 2008-8-9 离线

[查看资料]  [发短消息]  [Blog] 
       
发表于:2008-6-28 13:17　
来看看

论坛活动：测测你对IT技术大会的了解指数(赠微软礼品、无忧币)
2008-6-28 13:174楼
[ 顶部 ]
     
论坛跳转:  

| | |
| | |
| | |
标记已读 · 删除论坛Cookies · 文本版 · WAP
 
| 诚征版主 | 版主堂 | 意见建议 | 大史记 | 论坛地图
Copyright©2005-2008 51CTO.COM  Powered by Discuz!
本论坛言论纯属发布者个人意见，不代表51CTO网站立场！如有疑义，请与管理员联系。
京ICP备05051492号