DB Mail with CSV Attachment to Users by using BCP command
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[EmailReport] @ReportName AS VARCHAR(10) , @Country AS VARCHAR(4000) , @Date AS DATE , @FromDate AS DATE , @ToDate AS DATE , @Schedule AS VARCHAR(4000) , @Mailrecipients as varchar(4000) AS BEGIN DECLARE @Datestring varchar(100) SET @Datestring = CONVERT(VARCHAR(10), @Date, 101) PRINT @Datestring DECLARE @FileName AS VARCHAR(4000) DECLARE @string AS VARCHAR(4000) DECLARE @Columns AS VARCHAR(4000) DECLARE @MailSubject AS VARCHAR(4000) DECLARE @MailBody AS VARCHAR(4000) SET @MailBody = 'Attached is the ' + @Schedule + ' Report. Please do not Reply back as this is a System Generated Email.' IF (@ReportName = 'Employee Details') BEGIN -- Generate the Report SET @FileName = 'E:\Employee\SQLJob\EmployeeRecord'+Replace (@Country,' ','')+ CONVERT(VARCHAR(10), @Date, 112)+ '.CSV' -- Command Shell for Rep...