Database

SELECT DISTINCT 
	FARM_BOUND.OBJECTID AS BOUNDARY_AREA_ID, LB.CLASS AS CLASS_ID, 
	LB.GENERAL_PLAN_NO AS GP_NUMBER, LB.REMARK AS REMARKS, 
	LB.DATE_CAPTURED, LB.DATE_MODIFIED, 
	LB.PROCLAMATION_DATE AS DATE_PROCLAIMED, FILEMAP.REGION AS SG_REGION, 
	sde.VW_BOUNDARY_AREA_CLASS.CLASS AS CLASS, BC.EXTENSION, BC.NUMKEY AS NUM_KEY,
	FARM_BOUND.GEOCODE AS GEO_CODE, FARM_BOUND.NAME, FARM_BOUND.NAME AS BOUNDARY_AREA, FARM_BOUND.STATUS AS STATUS_ID, 
	sde.VW_BOUNDARY_AREA_STATUS.STATUS, 
	CASE WHEN LB.MUNICIPAL_STATUS = 0 --changed from VARCHAR to INT 2005-11-24 --'0' 
	THEN	'WITHIN'
	--ELSE
	--	CASE WHEN LB.MUNICIPAL_STATUS = 'WITHIN' 
	--	THEN	'WITHIN'
		ELSE	'OUTLYING' 
	--	END 
	END AS MUNIC_STATUS
FROM	sde.VW_BOUNDARY_AREA_STATUS 
	RIGHT OUTER JOIN sde.FARMBOUNDARY_PLUS_LANDBOUNDARY FARM_BOUND 
	ON sde.VW_BOUNDARY_AREA_STATUS.STATUS_ID COLLATE SQL_Latin1_General_CP1_CI_AS = FARM_BOUND.STATUS COLLATE SQL_Latin1_General_CP1_CI_AS
	LEFT OUTER JOIN CENETGIS001.Surveyor_General.sg_admin.SG_INDEX FILEMAP 
	RIGHT OUTER JOIN CENETGIS001.SDE.sde.LANDBOUNDARY LB
	LEFT OUTER JOIN sde.VW_BOUNDARY_AREA_CLASS 
	ON LB.CLASS COLLATE Latin1_General_CI_AS = VW_BOUNDARY_AREA_CLASS.CLASS_ID  COLLATE SQL_Latin1_General_CP1_CI_AS
	ON FILEMAP.SG_NO COLLATE Latin1_General_CP1_CI_AS = LB.GENERAL_PLAN_NO COLLATE SQL_Latin1_General_CP1_CI_AS
	ON FARM_BOUND.GEOCODE COLLATE Latin1_General_CP1_CI_AS = LB.GEOCODE COLLATE Latin1_General_CP1_CI_AS
	LEFT OUTER JOIN CENETGIS001.SDE.SDE.BOUNDARY_CODES BC 
	ON BC.GEOCODE  COLLATE Latin1_General_CI_AS = FARM_BOUND.GEOCODE COLLATE SQL_Latin1_General_CP1_CI_AS

Msg 447, Level 16, State 0, Procedure VW_BOUNDARY_AREA, Line 7
Expression type int is invalid for COLLATE clause. 

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.