SQL: Cursor

gistfile1.sql

declare @message nvarchar(250)

DECLARE #cursor_name# CURSOR FOR 
#select_statement#
OPEN #cursor_name#;
FETCH NEXT FROM #cursor_name# 
INTO @#variable#;

WHILE @@FETCH_STATUS = 0
BEGIN
	select @message = '#execute_statement#'
        execute sp_executesql @message;

	FETCH NEXT FROM #cursor_name# 
	INTO @#variable#;
END
CLOSE #cursor_name#;
DEALLOCATE #cursor_name#;