回答編集履歴
2
推敲
test
CHANGED
|
@@ -22,7 +22,7 @@
|
|
|
22
22
|
|
|
23
23
|
, case when ID2=1 then
|
|
24
24
|
|
|
25
|
-
|
|
25
|
+
(select 住所 from K3_Sheet1 ID in (t1.ID, t1.ID+1, t1.ID+2) for xml path(''))
|
|
26
26
|
|
|
27
27
|
end as 住所
|
|
28
28
|
|
1
推敲
test
CHANGED
|
@@ -14,11 +14,11 @@
|
|
|
14
14
|
|
|
15
15
|
select ROW_NUMBER()OVER(ORDER BY ID) as ID
|
|
16
16
|
|
|
17
|
-
,
|
|
17
|
+
, 姓
|
|
18
18
|
|
|
19
|
-
,
|
|
19
|
+
, 名
|
|
20
20
|
|
|
21
|
-
,
|
|
21
|
+
, 性別
|
|
22
22
|
|
|
23
23
|
, case when ID2=1 then
|
|
24
24
|
|
|
@@ -26,7 +26,7 @@
|
|
|
26
26
|
|
|
27
27
|
end as 住所
|
|
28
28
|
|
|
29
|
-
,
|
|
29
|
+
, 年齢
|
|
30
30
|
|
|
31
31
|
, ID2
|
|
32
32
|
|