sql - Collation help needed -

sql - Collation help needed -

i have issue collation on stored procedure, think issue in section don't know plenty collation resolve it, ive tried adding various sections hasn't worked. if shouldn't go in section can @ rest of query should added anywhere have used temp table?

the collation issue have is:

conflict between "sql_latin1_general_cp1_ci_as" , "latin1_general_ci_as"

create table #tmp_norotadayoff (dayofyear datetime, rota varchar(10), rotatemplate varchar(50))

note: modified original reply remove of code, bit left affected , caused issue

the default collation tempdb instance collation. can specify database_default @ column level temp tables in order utilize current database default collation instead. try:

create table #tmp_norotadayoff ( dayofyear datetime , rota varchar(10) collate database_default , rotatemplate varchar(50) collate database_default );

sql sql-server collation