Retail sales in the UK during August were flat, according to the CBI's latest Distributive Trades Survey, but business sentiment deteriorated sharply.