But using a table variable "@myTbleVarible" needs to be defined first with the same schema (column order and data type same as returning from stored procedure result set) only then it can be used to receive the result from the stored procedure.