如何在SELECT查询中调用存储过程？

I have a store procedure that takes in a uniqueidentifier and returns a table. What I am trying to do is to use these results like a regular table, but I realize SQL is still limited and doesn't allow it (yet!)I have a store procedure that takes in a unique