I had the exact same problem... trying to reference a column added to a temp table in the same batch using SQL Server 2000, within a stored proc.

What I got...