Query below has fixed length values for data set being returned in a string, now the problem is that fixed lengths are not being honored in the query results. But the output text file produced by DB mail looks correct. See examples below:
SELECT
LEFT(CONVERT(char(9), machine) + SPACE(9),9)
+ LEFT(CONVERT(char(30), part_no) + SPACE(30), 30)
+ LEFT(CONVERT(char(7), ordered) + SPACE(7), 7)
+ LEFT(CONVERT(char(7), picked) + SPACE(7), 7)
+ LEFT(CONVERT(char(7), allocated) + SPACE(7), 7)
+ LEFT(CONVERT(char(7), in_stock) + SPACE(7), 7)
+ LEFT(CONVERT(char(7), sh_bin_qty) + SPACE(7), 7)
+ LEFT(CONVERT(char(7), short) + SPACE(7), 7)
+ min_bin
Raw Output Results
Text File Results