Notes

CREATE PROCEDURE [dbo].[SP2_Il_Ozet_Bilgi_Yazdir]
AS

BEGIN
DECLARE @cvIlAdi VARCHAR(100)
DECLARE @cvIlKodu VARCHAR(100)
DECLARE @cvIlceAdi VARCHAR(100)
DECLARE @cvIlceKodu VARCHAR(100)
DECLARE @SQL VARCHAR(MAX)

DECLARE curIller CURSOR FAST_FORWARD FOR
SELECT [il_kodu], [il_adi]
FROM T_ILLER
ORDER BY [bolge_no];
OPEN curIller
FETCH NEXT FROM curIller
INTO @cvIlAdi, @cvIlKodu

SET @SQL = '';

WHILE @@FETCH_STATUS = 0
BEGIN

SET @SQL = CAST(@cvIlAdi AS VARCHAR)
+ '. ' +@cvIlKodu + ': ' ;
DECLARE curIller CURSOR FAST_FORWARD FOR
SELECT il_kodu, il_adi
FROM T_ILLER
WHERE bolge_no = @cvIlAdi
ORDER BY il_kodu;

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

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 curIller
INTO @cvIlKodu, @cvIlAdi
END
CLOSE curIller
DEALLOCATE curIller

END