• Maybe of you guys can either find or repost the script and post the link back here? Others will be interested Im sure.

    Greg, have you looked to see what performance implications of specifying a collation in the join? I use the technique myself when I need a case sensitive join on data that is stored case insensitive.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/