GET STORED PROCEDURE RESULT SET TO TEMP TABLE

I wanted to insert stored procedure result into my temp table.
I tried 'SELECT * INTO FROM EXEC MYPROC @.MYPARAM = 1', but it does not work.
any information is great appreciated,Hi
You can try this way
INSERT INTO #tempTable EXEC MYPROC @.MYPARAM = 1
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"Souris" wrote:

> I wanted to insert stored procedure result into my temp table.
> I tried 'SELECT * INTO FROM EXEC MYPROC @.MYPARAM = 1', but it does not wor
k.
> any information is great appreciated,
>