• 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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.