Notes

CREATE PROCEDURE [dbo].[SP1_Bolgelerdeki_Illeri_Yazdir]
AS
BEGIN
DECLARE @cvBolgeNo INT
DECLARE @cvBolgeAdi VARCHAR(100)
DECLARE @cvIlAdi VARCHAR(100)
DECLARE @cvIlKodu VARCHAR(100)
DECLARE @SQL VARCHAR(MAX)

DECLARE curBolgeler CURSOR FAST_FORWARD FOR
SELECT [bolge_no], [bolge_adi]
FROM T_BOLGELER
ORDER BY [bolge_no];

OPEN curBolgeler
FETCH NEXT FROM curBolgeler
INTO @cvBolgeNo, @cvBolgeAdi

SET @SQL = '';

WHILE @@FETCH_STATUS = 0
BEGIN


SET @SQL = CAST(@cvBolgeNo AS VARCHAR)--SONRADAN EKLEDİĞİMİZ
+ '. ' +@cvBolgeAdi + ': ' ;


DECLARE curIller CURSOR FAST_FORWARD FOR
SELECT il_kodu, il_adi
FROM T_ILLER
WHERE bolge_no = @cvBolgeNo
ORDER BY il_kodu;

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

WHILE @@FETCH_STATUS = 0
BEGIN

SET @SQL = @SQL + ': ' +@cvIlKodu + '-' +@cvIlAdi + ';';--YUKARIYI DEĞİŞTİRİNCE BURAYIDA DEĞİŞTİRDİK




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

PRINT (@sql)

FETCH NEXT FROM curBolgeler
INTO @cvBolgeNo, @cvBolgeAdi
END
CLOSE curBolgeler
DEALLOCATE curBolgeler

END
GO