MSSQL, temporary tables and CI

[eluser]docevi1[/eluser]
Aha! Solved it!

Looks like the drop commands at the bottom of the query aren't ran correctly and the temporary tables still exist in the catalog. Chucked a drop check for existence and drop to the top of the SP and job's a goodun.