USP_BATCH_GETLISTFORTEMPLATE
Returns a list of all batches for a given batch template.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_BATCH_GETLISTFORTEMPLATE(@BATCHTEMPLATEID uniqueidentifier)
as
set nocount on;
select BATCH.ID, BATCH.BATCHNUMBER, BATCH.FORMDEFINITIONXML
from dbo.BATCH
where BATCH.BATCHTEMPLATEID = @BATCHTEMPLATEID
order by BATCH.BATCHNUMBER;