Some queries failing when Server collation != database collation

[Brian Lewis]

Most of these problems are fixed; the solution is generally to replace references to temporary tables CREATE TABLE #data

with a table variable

DECLARE #data TABLE