[dba-SQLServer] Invalid column name dbo.

Stuart McLachlan stuart at lexacorp.com.pg
Thu Oct 29 17:09:12 CDT 2015


Damn.  Make that #MovePKs.PKMove and #MovePKs.dbo.PKMove



On 30 Oct 2015 at 7:59, Stuart McLachlan wrote:

> 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
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 




More information about the dba-SQLServer mailing list