Hi Guys,

Is it possible to pass a select statement as a parameter on stored procedures?

The Idea is to create a Stored Procedure that will accept a Select Statement as a parameter from the calling program.

The parameter will then be used in the stored procedure when declaring cursors.


Ex. DECLARE mycur CURSOR FOR @selectparam (Something like this...)


Thanks in advance...