Error:Msg 468, Level 16, State 9, Procedure CreditRecal1_Update, Line 50
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.
Update m Set m.CreditLeft = t.CreditLeft
From mMemberProfile m Inner Join #Temp t On t.UserId = m.UserId
Inner Join mMemberTree mt On mt.UserId = t.UserId
Where mt.[Role] = 'MEM'
Why is it so?
View Complete Post