USP_REPORT_STEWARDSHIPPLANSTEPUPDATEBATCHEXCEPTIONREPORT

Returns the data necessary for the stewardship plan step update batch report.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_REPORT_STEWARDSHIPPLANSTEPUPDATEBATCHEXCEPTIONREPORT 
(
   @BATCHID uniqueidentifier
) 
with execute as owner
as
begin
  set nocount on;

  declare @TABLENAME nvarchar(128);
    select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 1)

    declare @SQLTOEXEC nvarchar(400);

    set @SQLTOEXEC = N'set nocount on;
        select 
            ID,   
      NAME, 
      PLANNAME, 
      CATEGORY, 
      OBJECTIVE, 
      STATUS,
      REASON
        from dbo.' + @TABLENAME;

    exec sp_executesql @SQLTOEXEC;
end