Monthly Archives: January 2012

Sorting a String as a Number with T-SQL and SSIS

Posted on January 23, 2012 by MikeDavisSQL

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 … Continue reading →

Posted in SSIS, Syndication, T-SQL | Tagged , | 2 Comments