d*e
2 楼
〉〉〉〉many thanks
g*y
3 楼
I recently set up a phpbb forum but it is pur English. Can anyone give me
some ideas how to do that?
some ideas how to do that?
i*i
4 楼
I have a question about T- SQL language.
I wrote a query to get the SUM of every line's Amount with the same
Initiative Key.
SELECT
[Initiative Key]
,[Amount]
,SUM ([Amount]) OVER (PARTITION BY ([Initiative Key])) AS SUM_AMOUNT
FROM [DataClean].[dbo].['Initiative Donations$']
ORDER BY SUM_AMOUNT DESC
Here is the result,
Initiative Key Amount SUM_AMOUNT
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
but in my final report. I only want to know Initiative Key and SUM_Amount (
removing the duplicates). Is there any way to write those queries in one
file.
Initiative Key SUM_AMOUNT
KBERFVSJRZIL 380
97KB07RMROIK 375
I wrote a query to get the SUM of every line's Amount with the same
Initiative Key.
SELECT
[Initiative Key]
,[Amount]
,SUM ([Amount]) OVER (PARTITION BY ([Initiative Key])) AS SUM_AMOUNT
FROM [DataClean].[dbo].['Initiative Donations$']
ORDER BY SUM_AMOUNT DESC
Here is the result,
Initiative Key Amount SUM_AMOUNT
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 25 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
KBERFVSJRZIL 10 380
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
97KB07RMROIK 25 375
but in my final report. I only want to know Initiative Key and SUM_Amount (
removing the duplicates). Is there any way to write those queries in one
file.
Initiative Key SUM_AMOUNT
KBERFVSJRZIL 380
97KB07RMROIK 375
c*y
5 楼
接触onenote 不久，对其性能还不熟悉。 今天碰到了个问题不知怎么解决。
我试图通过"print" 功能将word 文档，PPT 或是Webpage 导入 onenote. 以前都没有
问题， 不知怎么的，今天onenote 不听使唤了，每次导入时总是跳出一个窗口说“
onenote cannot find a page on which to insert your printout. Navigate to a
page in your notebook, and then try again." 我不知道怎么做。
请高人指点。
我试图通过"print" 功能将word 文档，PPT 或是Webpage 导入 onenote. 以前都没有
问题， 不知怎么的，今天onenote 不听使唤了，每次导入时总是跳出一个窗口说“
onenote cannot find a page on which to insert your printout. Navigate to a
page in your notebook, and then try again." 我不知道怎么做。
请高人指点。
n*r
6 楼
国内大专可以吗
另外什么样的背景对申请会有帮助，
比如在公司里有过管理经验会不会好一点
另外什么样的背景对申请会有帮助，
比如在公司里有过管理经验会不会好一点
M*a
7 楼
目前我一个朋友人在亚利桑那州，有本州的2个教师执照，还有3年多的中文教学经验，
如果她打算去加州当老师的话，需要考哪些执照？还有，哪些地区位置空缺多些，如果
有的话。
谢谢大家。各位老师准老师，2011快乐！
如果她打算去加州当老师的话，需要考哪些执照？还有，哪些地区位置空缺多些，如果
有的话。
谢谢大家。各位老师准老师，2011快乐！
L*9
8 楼
Never heard this term before. Are you sure of it?
【在 d*******e 的大作中提到】
: 〉〉〉〉many thanks
【在 d*******e 的大作中提到】
: 〉〉〉〉many thanks
w*g
9 楼
http://www.phpbb.com/languages/
language pack.
不过我建议你用discuz
language pack.
不过我建议你用discuz
B*g
10 楼
http://www.w3schools.com/sql/sql_groupby.asp
【在 i****i 的大作中提到】
: I have a question about T- SQL language.
: I wrote a query to get the SUM of every line's Amount with the same
: Initiative Key.
: SELECT
: [Initiative Key]
: ,[Amount]
: ,SUM ([Amount]) OVER (PARTITION BY ([Initiative Key])) AS SUM_AMOUNT
: FROM [DataClean].[dbo].['Initiative Donations$']
: ORDER BY SUM_AMOUNT DESC
: Here is the result,
【在 i****i 的大作中提到】
: I have a question about T- SQL language.
: I wrote a query to get the SUM of every line's Amount with the same
: Initiative Key.
: SELECT
: [Initiative Key]
: ,[Amount]
: ,SUM ([Amount]) OVER (PARTITION BY ([Initiative Key])) AS SUM_AMOUNT
: FROM [DataClean].[dbo].['Initiative Donations$']
: ORDER BY SUM_AMOUNT DESC
: Here is the result,
L*k
11 楼
happy 2011！！
【在 M**a 的大作中提到】
: 目前我一个朋友人在亚利桑那州，有本州的2个教师执照，还有3年多的中文教学经验，
: 如果她打算去加州当老师的话，需要考哪些执照？还有，哪些地区位置空缺多些，如果
: 有的话。
: 谢谢大家。各位老师准老师，2011快乐！
【在 M**a 的大作中提到】
: 目前我一个朋友人在亚利桑那州，有本州的2个教师执照，还有3年多的中文教学经验，
: 如果她打算去加州当老师的话，需要考哪些执照？还有，哪些地区位置空缺多些，如果
: 有的话。
: 谢谢大家。各位老师准老师，2011快乐！
d*e
12 楼
牙医学院档案原文照抄
非常之Sure。
非常之Sure。
g*y
13 楼
thank you so much! I just tried discuz as you suggested. very powerful.
but page speed is not as fast as phpbb.
【在 w*****g 的大作中提到】
: http://www.phpbb.com/languages/
: language pack.
: 不过我建议你用discuz
but page speed is not as fast as phpbb.
【在 w*****g 的大作中提到】
: http://www.phpbb.com/languages/
: language pack.
: 不过我建议你用discuz
s*o
14 楼
你QUERY写错了吧
SELECT
[Initiative Key]
,SUM ([Amount])
FROM [DataClean].[dbo].['Initiative Donations$']
GROUP BY [Initiative Key]
SELECT
[Initiative Key]
,SUM ([Amount])
FROM [DataClean].[dbo].['Initiative Donations$']
GROUP BY [Initiative Key]
c*s
15 楼
请去www.edjoin.org寻找空缺位置。那个网站上的职位是按照county-school district
方式搜索的比较方便。不过我相信大量空缺出现的时段应该是在3月份之后.
【在 M**a 的大作中提到】
: 目前我一个朋友人在亚利桑那州，有本州的2个教师执照，还有3年多的中文教学经验，
: 如果她打算去加州当老师的话，需要考哪些执照？还有，哪些地区位置空缺多些，如果
: 有的话。
: 谢谢大家。各位老师准老师，2011快乐！
方式搜索的比较方便。不过我相信大量空缺出现的时段应该是在3月份之后.
【在 M**a 的大作中提到】
: 目前我一个朋友人在亚利桑那州，有本州的2个教师执照，还有3年多的中文教学经验，
: 如果她打算去加州当老师的话，需要考哪些执照？还有，哪些地区位置空缺多些，如果
: 有的话。
: 谢谢大家。各位老师准老师，2011快乐！
L*9
16 楼
OK, I did some research on my own and found out it's a very very old term.
Let me give you a description and then I will come up a current equivalent
term. "Mechanical Dentist" is not really a dentist at all, for he is not in
actual contact with patients, but a skilled mechanic who makes in his
laboratory the artificial materials (such as crowns, bridges and plates)
needed by the dental practitioner. Nowadays, it's call Certified Dental
Technician (牙科技师).
Let me give you a description and then I will come up a current equivalent
term. "Mechanical Dentist" is not really a dentist at all, for he is not in
actual contact with patients, but a skilled mechanic who makes in his
laboratory the artificial materials (such as crowns, bridges and plates)
needed by the dental practitioner. Nowadays, it's call Certified Dental
Technician (牙科技师).
i*i
17 楼
Thank you Beijing. It is very easy to use Group By. I always think of
Partition .....
【在 B*****g 的大作中提到】
: http://www.w3schools.com/sql/sql_groupby.asp
Partition .....
【在 B*****g 的大作中提到】
: http://www.w3schools.com/sql/sql_groupby.asp
L*k
18 楼
谢谢分享信息！
district
【在 c****s 的大作中提到】
: 请去www.edjoin.org寻找空缺位置。那个网站上的职位是按照county-school district
: 方式搜索的比较方便。不过我相信大量空缺出现的时段应该是在3月份之后.
district
【在 c****s 的大作中提到】
: 请去www.edjoin.org寻找空缺位置。那个网站上的职位是按照county-school district
: 方式搜索的比较方便。不过我相信大量空缺出现的时段应该是在3月份之后.
d*e
19 楼
millions of thanks
But I guess he could teach, so I translated it to be 技术牙科教师 or anyway
he was a demonstrator. So, I think 牙科教师 or 牙科技师 are both good.
thanks again.
But I guess he could teach, so I translated it to be 技术牙科教师 or anyway
he was a demonstrator. So, I think 牙科教师 or 牙科技师 are both good.
thanks again.
i*i
20 楼
Thank you very much. It works with Group BY.
【在 s**********o 的大作中提到】
: 你QUERY写错了吧
: SELECT
: [Initiative Key]
: ,SUM ([Amount])
: FROM [DataClean].[dbo].['Initiative Donations$']
: GROUP BY [Initiative Key]
【在 s**********o 的大作中提到】
: 你QUERY写错了吧
: SELECT
: [Initiative Key]
: ,SUM ([Amount])
: FROM [DataClean].[dbo].['Initiative Donations$']
: GROUP BY [Initiative Key]
M*a
21 楼
谢谢calous! Happy New Year!
district
【在 c****s 的大作中提到】
: 请去www.edjoin.org寻找空缺位置。那个网站上的职位是按照county-school district
: 方式搜索的比较方便。不过我相信大量空缺出现的时段应该是在3月份之后.
district
【在 c****s 的大作中提到】
: 请去www.edjoin.org寻找空缺位置。那个网站上的职位是按照county-school district
: 方式搜索的比较方便。不过我相信大量空缺出现的时段应该是在3月份之后.
y*w
22 楼
if partition, remove amount, plus distinct.
【在 i****i 的大作中提到】
: I have a question about T- SQL language.
: I wrote a query to get the SUM of every line's Amount with the same
: Initiative Key.
: SELECT
: [Initiative Key]
: ,[Amount]
: ,SUM ([Amount]) OVER (PARTITION BY ([Initiative Key])) AS SUM_AMOUNT
: FROM [DataClean].[dbo].['Initiative Donations$']
: ORDER BY SUM_AMOUNT DESC
: Here is the result,
【在 i****i 的大作中提到】
: I have a question about T- SQL language.
: I wrote a query to get the SUM of every line's Amount with the same
: Initiative Key.
: SELECT
: [Initiative Key]
: ,[Amount]
: ,SUM ([Amount]) OVER (PARTITION BY ([Initiative Key])) AS SUM_AMOUNT
: FROM [DataClean].[dbo].['Initiative Donations$']
: ORDER BY SUM_AMOUNT DESC
: Here is the result,
相关阅读
wjgsh 我有个问题直接问你得了~这几天Laukeen是不是回国了？请教下 -读了教育可以去公司做培训吗有对CALL 感兴趣或者是这方面的专家吗?大家有没有兴趣电话会议聊聊？感谢大家的支持(继续征集意见中）刚收到个面试通知教育专业的奖学金是不是不好拿啊？后天电话面试advisor 今天来听课了student teaching, portfolio, interview前几天的campus interview有一个调查作业，各位前辈能否帮帮忙回答一下！十分感谢！treesh是新版主？中文教师的Openings各位考praxis1的都用什么书啊？这个链接里有好多对教学有有用的内容。分享，问问大家哪个学校好?Reference的问题