Notes

CREATE PROCEDURE [dbo].[SP2_Il_Ozet_Bilgi_Yazdir]
AS
BEGIN
DECLARE
@cvIlce_Kodu INT,
@cvIlceAdi VARCHAR(100),
@cvIlKodu VARCHAR(100),
@cvIlAdi VARCHAR(100),
@SQL VARCHAR(MAX)

DECLARE curBolgeler CURSOR FAST_FORWARD FOR
SELECT ilce_kodu, ilce_adi
FROM [dbo].[T_ILCELER]
ORDER BY ilce_kodu;

OPEN curIlceler
FETCH NEXT FROM curIlceler
INTO @cvIlceKodu, @cvIlceAdi

SET @SQL = '';

WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE curIller CURSOR FAST_FORWARD FOR
SELECT il_kodu, il_adi
FROM [dbo].[T_ILLER]
WHERE Ilce_Kodu = @cvIlceKodu
ORDER BY il_kodu;

OPEN curIller
FETCH NEXT FROM curIller
INTO @cvIlKodu, @cvIlAdi

SET @SQL = CAST(@cvIlceKodu AS VARCHAR)
+ '. ' + @cvIlceAdi + ': ';

WHILE @@FETCH_STATUS = 0
BEGIN
SET @SQL = @SQL + @cvIlKodu
+ '-' + @cvIlAdi + ';';

FETCH NEXT FROM curIller
INTO @cvIlKodu, @cvIlAdi
END
CLOSE curIller
DEALLOCATE curIller

PRINT @SQL

FETCH NEXT FROM curBolgeler
INTO @cvIlceKodu, @cvIlceAdi
END
CLOSE curIlceler
DEALLOCATE curIlceler
END