USP_REPORT_EXCHANGEEMAILBATCHCONTROL
Returns data to be used in the Exchange Email Batch Control Report.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_REPORT_EXCHANGEEMAILBATCHCONTROL
(
@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,
OBJECTIVE,
EXPECTEDDATE,
USERNAME
from
dbo.' + @TABLENAME + '
order by
KEYNAME, FIRSTNAME, MIDDLENAME';
exec sp_executesql @SQLTOEXEC;