none
Email CSV file RRS feed

  • Question

  • We have a stored procedure and job that will email out invoices daily. It all works great, however, we are trying to get the current date in the CSV filename.

    Here is the line we are using now for the filename:

    @query_attachment_filename = 'test.csv'

    We are thinking of 3 different formatting options:

    1. MMDDYYYY.csv
    2. Wynne-MMDDYYYY.csv
    3. MMDDYYYY-Wynne.csv

    Thank you for any help!

    Monday, October 5, 2020 7:00 PM

All replies

  • Hi ITMgr,

    The purpose of this forum is to support the Open Specifications documentation. You can read about the Microsoft Open Specifications program at https://msdn.microsoft.com/en-us/openspecifications/default. The library of Open Specification documents is located at https://msdn.microsoft.com/library/dd208104.aspx.

     

    It doesn’t appear that you are implementing one of the protocols cited. if you are working with a specific on-the-wire Windows protocol please provide additional information regarding which protocol so that we can better understand how we can assist you.

    Otherwise, we suggest posting your question on the following forum:

    SQL Forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

    Best regards,


    Jeff McCashland | Microsoft Protocols Open Specifications Team

    Tuesday, October 6, 2020 4:27 AM
    Moderator