SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS ( SELECT * FROM sysobjects WHERE name = 'generateCSV' )
  DROP procedure dbo.generateCSV
GO
 CREATE procedure dbo.generateCSV

(
  @table varchar(100),
  @output varchar(100), -- u formatu
  @date varchar(12),
  @username varchar(20),
  @password varchar(100),
  @server varchar(30)
)

AS

DECLARE @sql varchar(8000)
SELECT @sql = 'bcp "select * from ' + DB_NAME() + '..' + @table  + ' where
reportingdate = ''' + @date + '''"' + ' queryout ' +  @output + '  -c -
C65001 -t"; " -r"n" -U' + @username + ' -P' + @password + ' -S' + @server -
 -+ @@servername

 exec master..xp_cmdshell @sql

GO

--EXEC dbo.generateCSV @table = 'Clients', @date = '2017-10-31', @output =
  --'E:Test.csv', @username = 'user', @password = 'pass', @server =
  -- '172.17.16.101'