USP_SIMPLEDATALIST_GENERATEBATCHOVERWRITEFIELDS
A list of all fields that can be overwritten for a given type.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_GENERATEBATCHOVERWRITEFIELDS
(
@BATCHTEMPLATEID uniqueidentifier = null
)
as
declare @retval as table
(
VALUE nvarchar(255),
LABEL nvarchar(255)
)
insert into @retval(VALUE, LABEL)
values
('Appeal', 'Appeal'),
('Campaign', 'Campaign'),
('Date', 'Date'),
('Designation', 'Designation'),
('Solicitor', 'Solicitor')
select VALUE, LABEL
from @retval