• It still throws an error...

    ALTER PROCEDURE [dbo].[usp_Names]

    (@ID int)

    AS

    DECLARE @TaskOutFile VARCHAR(255)

    DECLARE @sqlquery VARCHAR(100) = 'select * from dbo.Table where ID=@ID';

    SET @sqlquery = REPLACE(@SQLQuery,'@ID',@ID);

    Select @TaskOutFile = 'C:\' +@ID+ '.html'

    EXEC sp_makewebtask @outputfile =@TaskOutFile , @query = '@SQLQuery'

    Msg 139, Level 15, State 1, Procedure usp_SurgeonProcedures, Line 0

    Cannot assign a default value to a local variable.

    Msg 137, Level 15, State 2, Procedure usp_SurgeonProcedures, Line 6

    Must declare the scalar variable "@SQLQuery".