I have a stored procedure and I like to call this from select script.
This stored procedure returns a record with one column wichi is a recordset by select command inside.
How to call a stored procedure like below:
select ID, (exec sp_return_name_recordset 1000) as name
Stored procedure accepts ID and returns a records of name value.
how to combine select and stored procedure record in one record?