Temp Table collation conflict – Error : Cannot resolve the collation conflict between Latin1* and SQL_Latin1*
This happens because the collations on #tempdb.temp_po.OD1 and STR_IndentDetail.D1 are different (and specifically, note that #tempdb is a different, system database, which is generally why it will have a default opinion for collation, unlike your own databases and tables where you may have provided more specific opinions). Since you have control over the creation of … Read more