sql server - Formatting query of TSQL -
i have following tsql query attempting run results , attach email having issues formatting of query, can advise why not working? declare @query_attachment_filename varchar(100) = 'reconciliation-count-ending-' + convert(varchar(10), getdate(), 112) + '.csv'; exec msdb.dbo.sp_send_dbmail @profile_name = 'support', @recipients = 'johnpaul@energy.co.uk;martin@energy.co.uk', @subject = 'reconciliation count', @query = n'set ansi_warnings off;set nocount on;select * ( select a.new_messagetypecode new_marketmessagein createdon between dateadd(day, –1, getdate()) , getdate() ) src pivot (count(new_messagetypecode ) new_messagetypecode in ([014r], [101], [101p], [101r], [102], [102p], [102r], [105], [105l], [106d], [106e], [110], [111], [111a], [111l], [111r], [112], [112r], [112w], [114], [115], [115r], [116], [116a], [116n], [116r],[117d],[117r], [122], [122r], [130d], [130r], [131], [137r], [261], [300], [300s], [300w], [301], [...