• I was trying not to format the output as I wanted to compare the two tables. Its strange Im getting different results from the same sqlcmd on 2008 R2 and 2014.

    I found a work around, I ran the query as output to text file in SSMS and it gives out the correct format for both versions.