【已开帖】[73期]巧用SQL，无中生有万年历。

wuxiang_123 · 发表于 2011-4-27 12:43

截至日期：2011年05月21日前
各参赛者得分统计在5楼
要求：

演示动画：

[ 本帖最后由 wuxiang_123 于 2011-5-21 15:42 编辑 ]

ctp_119 · 发表于 2011-4-27 13:00

下载学习下。
？？？
我还以为是做好的。

[ 本帖最后由 ctp_119 于 2011-4-27 13:03 编辑 ]

小蚁雄兵 · 发表于 2011-5-4 15:23

请楼主过目，谢谢！

wudixin96 · 发表于 2011-5-5 10:33

transform first(日) select null from (
select CHOOSE(WEEKDAY(日期),"日","一","二","三","四","五","六") as 星期,datepart("ww",日期) as 周,日 FROM (select (select f1 from [sheet1$d1:d1])&"/"&日&"/"&(select f1 from [sheet1$b1:b1]) as 日期,日 from (
select 1 as 日 from [Sheet1$b1:b1] union
select 2 from [Sheet1$b1:b1] union
select 3 from [Sheet1$b1:b1] union
select 4 from [Sheet1$b1:b1] union
select 5 from [Sheet1$b1:b1] union
select 6 from [Sheet1$b1:b1] union
select 7 from [Sheet1$b1:b1] union
select 8 from [Sheet1$b1:b1] union
select 9 from [Sheet1$b1:b1] union
select 10 from [Sheet1$b1:b1] union
select 11 from [Sheet1$b1:b1] union
select 12 from [Sheet1$b1:b1] union
select 13 from [Sheet1$b1:b1] union
select 14 from [Sheet1$b1:b1] union
select 15 from [Sheet1$b1:b1] union
select 16 from [Sheet1$b1:b1] union
select 17 from [Sheet1$b1:b1] union
select 18 from [Sheet1$b1:b1] union
select 19 from [Sheet1$b1:b1] union
select 20 from [Sheet1$b1:b1] union
select 21 from [Sheet1$b1:b1] union
select 22 from [Sheet1$b1:b1] union
select 23 from [Sheet1$b1:b1] union
select 24 from [Sheet1$b1:b1] union
select 25 from [Sheet1$b1:b1] union
select 26 from [Sheet1$b1:b1] union
select 27 from [Sheet1$b1:b1] union
select 28 from [Sheet1$b1:b1] union
select 29 from [Sheet1$b1:b1] union
select 30 from [Sheet1$b1:b1] union
select 31 from [Sheet1$b1:b1])
) where isdate(日期)
) group by 周 pivot "星期"&星期 in ("星期日","星期一","星期二","星期三","星期四","星期五","星期六")

复制代码

[ 本帖最后由 wudixin96 于 2011-5-5 12:15 编辑 ]

wuxiang_123 · 发表于 2011-5-21 12:16

2楼不得分，三楼和四楼正解，技术各＋2

我的答案：

注意将链接字符串：HDR=YES改为HDR=NO。意思是第一行不作为字段标题。

[ 本帖最后由 wuxiang_123 于 2011-5-21 12:19 编辑 ]

wudixin96 · 发表于 2011-5-21 16:08

学习来了，原来你的方法是这样啊。

wuxiang_123 · 发表于 2011-5-21 16:11

是不是很失望

wudixin96 · 发表于 2011-5-21 16:20

也不早点告诉我有技术分得的，我以为只有财富得一下，哎，损失了你另外一个题了

minjiwei · 发表于 2011-5-23 18:11

版主的两个方法都得不出结果，不知道是什么原因？

wuxiang_123 · 发表于 2011-5-24 13:48

估计你是没有将HDR=YES改为HDR=NO

		自动登录	找回密码
密码			免费注册

[Excel 基础应用] 【已开帖】[73期]巧用SQL，无中生有万年历。