Subscribe to this blog
Archives: January 2012
Sorting a String as a Number with T-SQL and SSIS
I was working on a Cube in Analysis Services for a client recently and needed to sort on a field that was a varchar but contained numeric data. I wanted to sort as if it was numeric. I could not just convert this code to a number and sort on… Read more
2 comments, 845 reads
Posted in Mike Davis SQL on 23 January 2012