Call a procedure in SQL CTE

Call a procedure in SQL CTE

sql server 2005 – Call a Stored procedure in SQL CTE – Stack Overflow

sql server 2005 – Call a Stored procedure in SQL CTE – Stack Overflow

DECLARE @tbl TABLE(id int ,name varchar(500) ,...)      
    INSERT INTO @tbl        
    EXEC myprocedure @param ..

with cte as (
    SELECT * FROM @tbl  
)
select * from cte