I have a very good solution
from another expert that does a dynamic sql and returns a variable number of columns based on other input.
I placed that solution in a storedprocedure
Is there a way to do a select on a table with a join to the output from the stored procedure
If I knew the columns I could create table #temp
and insert into it with an exe on the procedure
But the variable length nature of the response precludes that