[dba-SQLServer] Invalid column name dbo., <accessd at databaseadvisors.com>

[Stuart McLachlan]

You have a column #MovePKs.Zip

You are trying to join on #MOvePKs.dbo.Zip


-- 
Stuart

On 29 Oct 2015 at 12:35, John Colby wrote:

> 
> Msg 207, Level 16, State 1, Procedure usp_MovesSimmons, Line 72
> Invalid column name 'dbo'.
> 
> I cannot see where there is a column named .dbo in the second select.
> 
> 
> Create Table #MovePKs (PKMove int, St char(2), Zip char(5), MSA Char
...
> insert into #MovePKs (PKMove, St, Zip, MSA, MSAPlusName)
...
> from #MovePKs
> Inner Join _DataSimmonsProtocolSimple.dbo.tblDB101SimmonsResultSimple
> ON #MovePKs.dbo.PKMove =
^^^^^^

> _DataSimmonsProtocolSimple.dbo.tblDB101SimmonsResultSimple.PKDb101