Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: sp_ AppendToFile does not create a file

    The full stored procedure is quite lengthy, I have reduced it down to the following:

    declare@DaysSMALLINT

    declare @FilePathNVARCHAR(20)

    Declare @OutputNVARCHAR(160)

    SET @Days = -2

    SET @FilePath = 'C:\SAPExport.txt'

    SELECT @output = AFC.dbo.OITM.ItemCode

    FROM AFC.dbo.OITM

    INNER JOIN AFC.dbo.ITM1...

  • RE: sp_ AppendToFile does not create a file

    Thank you for your assistance, there is a second Stored Procedure that runs a cursor to obtain the data to be written to the file. The only information in...

Viewing 2 posts - 1 through 3 (of 3 total)