SELECT  top 200  [ID] 主键
      ,[FuncMethod] [方法名]
      ,[ParamInfo]  [参数]
      ,[ExecuteTime] [执行时间]
      ,[RetryCount]  [重试次数]
      ,[ExceptionInfo] [报错内容]
      ,[FuncStatus] [任务状态]
      ,[Creater]  [创建人]
      ,[CreateTime]  [创建时间]
      ,[Editor]  [修改人]
      ,[EditTime]  [修改时间]
      ,[Remark]  [备注]
   
  FROM  [dbo].[SysWorkProcess]
  where '#FEndDate#'>[CreateTime]  
  and '#FStartDate#'<=[CreateTime]  
  ORDER BY [EditTime]  desc