I have been provided with a stored procedure and due to some policies with the CRM, I don't have access to the actual tables.
I just want to use the Where clause with whatever data I'm getting in the results from executing the stored procedure.
Is there a function or piece of code that could let me use Where with 'exec' or how can I just simply create a temp table or 'view'?