This is one of the way to use cursors built by Dynamic SQL.

CREATE PROCEDURE STP_DemoDynaCursor
@Table SYSNAME,
@Column SYSNAME,
@DynaCur CURSOR VARYING OUTPUT
AS
BEGIN
DECLARE @Sql NVARCHAR(500)
SELECT @Sql = 'SET @DynaCur = CURSOR STATIC FOR' +' SELECT '+ @Column +' FROM ' +@Table +'; OPEN @DynaCur;'
EXEC SP_EXECUTESQL @Sql, N'@DynaCur CURSOR OUTPUT', @DynaCur OUTPUT
END



Code to access above Procedure:

CREATE PROCEDURE STP_DemoDynaCurCall
@APTable SYSNAME,
@APColumn SYSNAME
AS
BEGIN
DECLARE @CurResultSet CURSOR
EXEC STP_DemoDynaCursor @Table = @APTable, @Column = @APColumn, @DynaCur = @CurResultSet OUTPUT
FETCH NEXT FROM @CurResultSet;
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM @CurResultSet
END
CLOSE @CurResultSet
DEALLOCATE @CurResultSet
END

Can anyone find some other script, Please post it...