>
>We're puzzled about why the extra # makes such a difference and any information you can provide
>will be a big help.
>
>Thanks.............Rich

Rich,

A single # sign indicates a local temp table (available only for the session that created it), whereas a ## sign indicates a global temp table (available for other sessions)

Here is a URL that covers the differences:

http://sqlmag.com/t-sql/temporary-tables-local-vs-global