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
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.