Is there a way to import a tables from a database that is a stored procedure?

If so, please provide details or link to steps.

I have tried to import from a stored procedure and have been unable to

Thanks