I have a table that will give me all the users id
Select userid from UserTable
I have a stored procedure that will give me the user workplace given the userid as arguement.
Exec GetUserWorkSpace userid
I am trying to find out how I can loop through 'Exec GetUserWorkSpace userid' for all the userid from UserTable. I would like to insert the result from GetUserWorkSpace into a table.
How can I write a SQL to do that?