>>>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.


OK...

So in the Query Analyzer I entered SET SHOWPLAN_TEXT ON

This was the result:

StmtText
------------------------------
SET STATISTICS PROFILE ON

(1 row(s) affected)

Server: Msg 208, Level 16, State 1, Line 16
Invalid object name '#temp'.
StmtText
-----------------------------
SET STATISTICS PROFILE OFF

(1 row(s) affected)


However with SET SHOWPLAN_TEXT OFF I do not get any errors...

Any ideas????

Thanks,
Mike