k**n
发帖数: 3989 | 1 【 以下文字转载自 HiFi 讨论区 】
发信人: kknn (浪客刀心@两条腿的青蛙), 信区: HiFi
标 题: 10磅重的klipsch s42能挂在ceiling上吗
发信站: BBS 未名空间站 (Thu Apr 4 00:14:13 2013, 美东)
两边墙有窗有门, 如果挂墙上就不对称,
不知有啥能把它挂到天花板上? |
|
j*****n
发帖数: 1781 | 2 Here is a question been asked...
先讨论一下第一题。我知道pivot的用法。但是这个考的好像和传统的不一样。我知道
的pivot一般都要和aggregate
function在一起用的。当然也可以不用aggregate function，但这样会有大量的null出
现。
我理解的题目意思是这样
1）把
colName1 colName2 colName3
s11 s12 s13
s21 s22 s23
s31 s32 s33
s41 s42 s43
变成
s11 s21 s31 s41
s12 s22 s32 s42
s13 s23 s33 s43
2） 然后用一个concate... 阅读全帖 |
|
k**n
发帖数: 3989 | 3 两边墙有窗有门, 如果挂墙上就不对称,
不知有啥能把它挂到天花板上? |
|
A*********l
发帖数: 2005 | 4 10 lb is not much. If you can find the ceiling joist, it is strong enough to
hold 10lb if you do your installation the right way. |
|
|
n*******d
发帖数: 600 | 6 Brand & Model Price Ratings and Test Results
***************************Lawn tractors
Price
info
overall score
info
overall score
Side discharging
info
Mulching
info
Bagging
info
Handling
info
Ease of use
info
CU Recommended John Deere X300 3 see here $3000
78
CU Best Buy Craftsman 20442 see here $2200
78
Cub Cadet GT 2042 see here $3600
77
Cub Cadet 13APA1CT056 see here... 阅读全帖 |
|
j*****n
发帖数: 1781 | 7 I had a solution but sounds stupid, post here see if anyone has better idea.
with Data (c1, c2, c3)
AS (
SELECT 's11', 's12', 's13'
union all
select 's21', 's22', 's23'
union all
select 's31', 's32', 's33'
union all
select 's41', 's42', 's43'
)
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c1, row_number() over (order by c1) as RN
FROM data) AS SourceTable
PIVOT
(
min(c1)
FOR rn IN ([1], [2], [3], [4])
) AS PivotTable
union all
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c2, row_... 阅读全帖 |
|
t*****s
发帖数: 1309 | 8 是这个，我才花80买了一个，悲催
不过这个的序列号我看不懂，G 000080 S42，和一般编号意义对不上 |
|
t*****s
发帖数: 1309 | 9 S42啊，像我这个4U6就是2008年第6周第4天产的 |
|
p*****u
发帖数: 191 | 10 如果有兴趣，可以看看这个综述
Visualization of macromolecular structures
Nature Methods 7,S42–S55(1 March 2010) | doi:10.1038/nmeth.1427
//www.nature.com/nmeth/journal/v7/n3s/full/nmeth.1427.html |
|
