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