setting crsor to a stored procedure sql2008

See more:

SQL-Server

SQL-Server-2008

, +

Hello All,

I want to set a cursor to a stored procedure which executes my select statement instead of directly setting it to a select statement, how can i do this?
I want to have only one cursor and set it to different stored procedures depending on some condition, there are two ways to do this as i have given below but the first one does not work and the second one does, i want to do it the first way which allows me to declare a single cursor which can be set to different select statements, but when it comes to stored procedure this kind of declaration is not working and the sql browser throws an error. Can anyone help me how i can do this?

declare @Cur as cursor
set @cur= CURSOR for  exec sp_Executesql @stmt

declare @cursor cursor exec sp_Executesql @stmt

Thanks in Advance,
Regards
Ravikiran