I haven't seen it so cannot comment on it.
>After searching some more, I found that syntax. It worked, and now I am back coding and not searching.
>
>I wonder why the other syntax is plastered all over the internet in referance to SQL 2008 if it is not valid? Sometimes I get frustrated when I encounter answers on the web that either unrelatered or flat out wrong.
>
>Thank for the reply.
>
>>It's invalid syntax. You have to create a [temp] table with columns that match SP recordset first and then
>>
>>INSERT INTO <table name> EXEC [mySP] 'para1'
>>
>>
>>
--sb--