Collation Conflict between databases (tempdb and user databases)

Msg 468, Level 16, State 9, Line 21
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

Use the COLLATE DATABASE_DEFAULT suffix on VARCHAR columns:

SELECT *
FROM hif_dim_account AS a
INNER JOIN #temp_hierarchy AS t
  ON t.account COLLATE DATABASE_DEFAULT = a.account COLLATE DATABASE_DEFAULT
INNER JOIN hif_dim_hierarchy AS h ON h.business_description COLLATE DATABASE_DEFAULT = t.business_description COLLATE DATABASE_DEFAULT