I created a stored procedure in Sql 2008R2.It has common table expression inside the procedure.
Create procedure dbo.usp_GetDetails as BEGIN
SET NOCOUNT ON;
I am trying to take everything in the cte to temp table using
But nothin in th temp table.
Same thing giving the details in query analyzer.
How to get it work in the procedure.