Jan Van der Eecken (10/18/2010)
Hi Brandie,I guess the final update back will fail on a database with a case sensitive collation. Shouldn't it rather read:
Update idf
Set Location = mt1.Location
from dbo.Import_Data_Filter idf
join dbo.#MyTemp1 mt1
on UPPER(idf.Location) = UPPER(mt1.Location);
Sorry it's been so long since you posted. I was working on massive projects.
Actually, Jan, your code would set everything back to Upper case which is what the customer did NOT want. He wanted Camel Case names.