MSSQLTips

This post is related to this tip: Importing Excel data using SSIS and dealing with unicode and non-unicode data issues http://www.mssqltips.com/tip.asp?tip=1393

A customer recently questioned me regarding a sorting issue they were having in the following scenario: My database is running under the "SQL_Latin1_General_CP1_CI_AS" Sql collation, but when I run the script below I seem to get incorrect sort results. Why does the "abc-test" item...