>>Can you provide an execution plan?
>>
>
>I'd like to but I'm not sure how... I ran the SP in hte Query Analyzer wirh Execution Plan set on, however I do not see a way to grab the results and set them over.
>
>Please advise....

check out SET SHOWPLAN_TEXT in the BOL.

-Mike