looking on the update statement

update #TempTotalTable

set NoOfCol = NoOfCol

from #ColumnPerTable

where #TempTotalTable.TBName = #ColumnPerTable.TBName

you might want to prefix the NoOfCol with #ColumnPerTable, i think you are setting the column with its...

Could it be that you have two mdf files assigned to one database?