How To Use BCP In Store Procedure (BCP Dalam Store Procedure)

 -- Insert statements for procedure here
    DECLARE @xdate SMALLDATETIME
    DECLARE @date VARCHAR(20)
    DECLARE @L_OUT_PATH VARCHAR(100)
    DECLARE @L_OUT_FILENAME VARCHAR(100)
    DECLARE @QUERY NVARCHAR(4000)
    DECLARE @sql NVARCHAR(4000)

    SET @xdate = (SELECT MAX(date) FROM MASTER.dbo.TABLE_NAME)
    SET @date = (select CAST(@xdate as DATE)) --USE CURRENT DATE INTO FILE_NAME
    SET @L_OUT_PATH = 'D:\FOLDER NAME\'
    SET @L_OUT_FILENAME = 'BCP_FILE_'+@date+'.txt'

    SET @QUERY = 'SELECT * FROM MASTER.dbo.TABLE_NAME WHERE [date] IN (SELECT MAX(date) FROM MASTER.dbo.TABLE_NAME)' --User Sub Query (GET MAX DATE)

    SET @QUERY = 'bcp "'+@QUERY+'" queryout '+@L_OUT_PATH+@L_OUT_FILENAME+' -c -S ServerName -Uusername -Ppassword'

    EXEC xp_cmdshell @QUERY


--THEN YOU CAN CREATE JOBS TO EXEC DAILY.