Initially I was going to call this article "Struggling With Collation: The SeQueL", but it just doesn’t have the same ring to it as "Fun With Strings".  In that previous article I showed how you might get different results when loading data from a temporary table or table variable and I suggested that one way [...]
Click here to see the original post

Recently I was investigating an issue related to ordering data.  As a test, I ran the following script: – Sorting data from a temporary table declare @tbl table ( ProductNumber varchar(25) ); insert into @tbl select ‘BBBB’; insert into @tbl select ‘AAAA’; insert into @tbl select ‘A-B’; insert into @tbl select ‘A123′; select * from @tbl order by ProductNumber asc; – [...]
Click here to see the original post