回答編集履歴
1
追記修正
test
CHANGED
@@ -116,6 +116,18 @@
|
|
116
116
|
|
117
117
|
) as B on B.Id=A.Id
|
118
118
|
|
119
|
+
|
120
|
+
|
121
|
+
-- もちろんこれでもOKです
|
122
|
+
|
123
|
+
select A.Data as 商品コード
|
124
|
+
|
125
|
+
,B.Data as 個数
|
126
|
+
|
127
|
+
from [dbo].[utf_Split]('1,2,3',',') as A
|
128
|
+
|
129
|
+
inner join [dbo].[utf_Split]('10,20,30',',') as B on B.Id=A.Id
|
130
|
+
|
119
131
|
```
|
120
132
|
|
121
133
|
↓実行結果
|