sql server 2005 - Call a Stored procedure in SQL CTE

Question

Are you allowed to exec stored procedures within a SQL CTE statement? I'm a bit new to sql cte queries...

Answer 1

No, sorry. SELECTs statments only

If you need to use stored proc output (result set), then it'd be a temp table

CREATE TABLE #foo (bar int...)

INSERT #foo (bar, ...)
EXEC myStoredProc @param1...

-- more code using #foo