How can a SQL Server stored procedure see an external cursor created for a Select sub-query? I.e:

SELECT MyFields FROM MyMainTable WHERE MyMainTable.LookupField IN ( SELECT LookUpField FROM MyCursor )

MyCursor has to be created external to the stored procedure ( as far as I know ) to allow user to select 1, some or all of the items in the LookUpField to be used in the sub-query. Or is there another way to do this? Is my description clear?

Thanks,
Bill