• yes I have three temp tables in my stored procedure.

    Won't it work if I have temp tables in SP?