> I'm not sure this will work because the scope for #temp will
> probably only be the exec call and it will be freed
> immediately after the exec finishes.
Correct - you must create the table first. I guess it highlights the
difference between behaviour in an actual stored proc and testing code in
query analyzer though, as it worked for me in QA.
Paul Ritchie
Radio Computing Services.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
