USP_REPORT_EXCHANGECALENDARITEMBATCHCONTROL
Returns data to be used in the Exchange Calendar Item Batch Control Report.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_REPORT_EXCHANGECALENDARITEMBATCHCONTROL
(
@BATCHID uniqueidentifier
)
as
set nocount on;
declare @TABLENAME nvarchar(128);
select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 0)
declare @SQLTOEXEC nvarchar(400);
set @SQLTOEXEC = N'set nocount on;
select
ID,
CONSTITUENTNAME,
RECORDTYPE,
OBJECTIVE,
TYPE,
EXPECTEDDATE
from
dbo.' + @TABLENAME + '
order by
KEYNAME, FIRSTNAME, MIDDLENAME';
exec sp_executesql @SQLTOEXEC;