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文の使い方メモ