質問編集履歴
20
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
19
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
18
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
17
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
16
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
15
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
14
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
13
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
12
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
11
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
10
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
9
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
8
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
7
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
6
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
5
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
4
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
|
1
|
+
うかかなゆかはらやや
|
test
CHANGED
File without changes
|
3
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
2
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
1
test
CHANGED
File without changes
|
test
CHANGED
@@ -1,109 +1,41 @@
|
|
1
1
|
```ここに言語を入力
|
2
2
|
|
3
|
-
|
3
|
+
コード
|
4
4
|
|
5
|
-
|
5
|
+
```### ```~~````````````````````````ここに言語を入力
|
6
6
|
|
7
|
-
|
7
|
+
ここに言語を入力
|
8
8
|
|
9
|
-
|
9
|
+
```
|
10
10
|
|
11
|
-
|
11
|
+
ここに言語を入力
|
12
12
|
|
13
|
-
|
13
|
+
```
|
14
14
|
|
15
|
-
|
15
|
+
ここに言語を入力
|
16
16
|
|
17
|
-
|
17
|
+
```
|
18
18
|
|
19
|
-
|
19
|
+
ここに言語を入力
|
20
20
|
|
21
|
-
|
21
|
+
```
|
22
22
|
|
23
|
-
|
23
|
+
ここに言語を入力
|
24
24
|
|
25
|
-
|
25
|
+
```
|
26
26
|
|
27
|
-
|
27
|
+
ここに言語を入力
|
28
28
|
|
29
|
-
|
29
|
+
```
|
30
30
|
|
31
|
-
|
31
|
+
ここに言語を入力
|
32
32
|
|
33
|
-
|
33
|
+
```
|
34
34
|
|
35
|
-
|
35
|
+
ここに言語を入力
|
36
36
|
|
37
|
-
|
37
|
+
```~~
|
38
38
|
|
39
|
-
|
39
|
+
ヘディングのテキスト
|
40
40
|
|
41
|
-
where ID2 is not null
|
42
|
-
|
43
|
-
) as TA
|
44
|
-
|
45
|
-
full join
|
46
|
-
|
47
|
-
(select
|
48
|
-
|
49
|
-
ID
|
50
|
-
|
51
|
-
|
41
|
+
```
|
52
|
-
|
53
|
-
from K3_Sheet1
|
54
|
-
|
55
|
-
where ID2=2 or ID=15
|
56
|
-
|
57
|
-
) as b
|
58
|
-
|
59
|
-
on TA.ID=TB.ID-1
|
60
|
-
|
61
|
-
full join
|
62
|
-
|
63
|
-
(select
|
64
|
-
|
65
|
-
ID
|
66
|
-
|
67
|
-
,住所
|
68
|
-
|
69
|
-
from K3_Sheet1
|
70
|
-
|
71
|
-
where ID2=3 or ID=12 or ID=16
|
72
|
-
|
73
|
-
) as c
|
74
|
-
|
75
|
-
on TA.ID=TC.ID-2
|
76
|
-
|
77
|
-
```### 前提・実現したいこと
|
78
|
-
|
79
|
-
sqlserver2008で
|
80
|
-
|
81
|
-
後でデータを追加しても二つ目の図のように表示できるようにしたいです。
|
82
|
-
|
83
|
-
インサートやアップデートは禁止です。
|
84
|
-
|
85
|
-
外部結合でなるべく表示してほしいと指示があったので
|
86
|
-
|
87
|
-
文を作ってみましたがデータが増えた時にこのコードだと書き換えないとだめだと却下されました。
|
88
|
-
|
89
|
-
ヒントを頂いてもよろしいでしょうか?
|
90
|
-
|
91
|
-
|
92
|
-
|
93
|
-
### このExcelの表を
|
94
|
-
|
95
|
-
![イメージ説明](ac83c051272e52310af4ccfa0fa1016f.png)
|
96
|
-
|
97
|
-
### 下の図のように出力したい
|
98
|
-
|
99
|
-
![イメージ説明](adc16fdd759b5c242ddf90d1969c2e64.png)
|
100
|
-
|
101
|
-
|
102
|
-
|
103
|
-
|
104
|
-
|
105
|
-
|
106
|
-
|
107
|
-
### 補足情報(FW/ツールのバージョンなど)
|
108
|
-
|
109
|
-
SQLserver 8を使用しています
|