USP_REPORT_PDACCOUNTSEGMENTMAPPINGBATCHCONTROL

Returns the data necessary for the Account Segment Mapping Batch Control report.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_REPORT_PDACCOUNTSEGMENTMAPPINGBATCHCONTROL(@BATCHID uniqueidentifier)
as
begin
    set nocount on;

    declare @TABLENAME nvarchar(128);

    select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 0)

    declare @SQLTOEXEC nvarchar(200);

    set @SQLTOEXEC = N'set nocount on;
        select
            ID, SEGMENTTYPE, SEGMENTNAME, SEGMENTVALUE
        from dbo.' + @TABLENAME;
        exec sp_executesql @SQLTOEXEC;
end