Home Forums SQL Server 2005 T-SQL (SS2K5) T-SQL RE: T-SQL

  • October 13, 2013 at 4:33 pm

    #1658145

    Try something like this

    DECLARE @TaskOutFile VarChar(255)

    select * from dbo.Table where ID=@ID

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

    EXEC sp_makewebtask @outputfile = @TaskOutFile, @query = 'select * from dbo.Table where ID=@ID'