I have the following error coming back at me
Msg 468, Level 16, State 9, Line 243
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Except that the server collations are all SQL_Latin1_General_CP1_CI_AS
The database collations are SQL_Latin1_General_CP1_CI_AS
The Table collations are SQL_Latin1_General_CP1_CI_AS
and the specific column in question is using SQL_Latin1_General_CP1_CI_AS as its collation as well.
This worked fine with SQL 2008 R2 SP1 SQL_Latin1_General_CP1_CI_AS and SQL 2005 SP3, is this something to do with SQL 2012 SP1?