I have an overnight task which creates various views and then executes (via xp_cmdshell) BCP commands against these views. I would like to customise the order of the data in the views, but CREATE VIEW does not allow ORDER BY. Suggestions invited!