shishimaruby https://blog.hatena.ne.jp/shishimaruby/ メモス＼(^o^)／ https://shishimaruby.hatenadiary.org/ DECLARE @A_ID INTEGER DECLARE @B_ID INTEGER DECLARE A_TABLE CURSOR FOR SELECT id FROM a_table OPEN A_TABLE FETCH NEXT FROM A_TABLE INTO @A_ID WHILE @@FETCH_STATUS = 0 BEGIN DECLARE B_TABLE CURSOR FOR SELECT id FROM b_table OPEN B_TABLE FETCH NEXT FROM B_TABLE INTO @B_ID WHILE @@FETCH_STATUS = 0 BEGI… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshishimaruby.hatenadiary.org%2Fentry%2F20100531%2F1275314636" title="SQL SERVERでFOR文を2回まわす(2重ループ) - メモス＼(^o^)／" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2010-05-31 23:03:56 rich https://shishimaruby.hatenadiary.org/entry/20100531/1275314636 1.0 100%