• Suppose this is my stored procedure

    CREATE PROCEDURE [dbo].[usp_test]

    AS

    select * from emp

    GO

    How do I export the results to an excel file with the name of the excel file changing every week

    Where do I plug in the code($nameoffile = 'my name' + getdate())which you mentioned.

    Thanks