I have a stored procedure that generated a query string and then executes it with
EXECUTE SP_EXECUTESQL @Query
The query, e.g., is:
Select Name, Age from tableA, so very simple.
But how to get the result set back from the
SP_EXECUTESQL (into a variable?) and then return it as result set in my stored procedure?