• looks like you are using global temporary tables which may cause blocking:

    http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html