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

Sure, as long as it doesn't exceed the varchar max lenght of 8000 bytes.

>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...)

Can you be more specific about what you're trying to do?