Hi Guys,
I just wondering what is the better way to replace 'COLLATE' or Some way we can declare it somewhere before we do on update statement. Because I have another 3 more similar UPDATE after that process and all in one store procedure, the same thing using with 'COLLATE', but those process are take so slow. Anyway can we improve this.
UPDATE dbo.EB_DETAIL
SET dbo.EB_DETAIL.EBNumber = @EBNumber
FROM #EBCustomer t
INNER JOIN dbo.EB_DETAIL c
ON t.EBCode = c.EBCode COLLATE DATABASE_DEFAULT
WHERE c.EBNumber=0
Thanks.