SQL SERVERでFOR文を2回まわす(2重ループ)
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 BEGIN PRINT (convert(varchar,@A_ID) + convert(varchar,@B_ID)) END CLOSE B_TABLE DEALLOCATE B_TABLE FETCH NEXT FROM @A_ID INTO @A_ID END CLOSE A_TABLE DEALLOCATE A_TABLE
sql serverのストアドプロシージャでのfor文の使い方メモ