USP_MKTDUPLICATE_GETDUPLICATEFIELDSFORRECORDSOURCE
Returns all duplicate fields defined for a corresponding record source.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECORDSOURCEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.[USP_MKTDUPLICATE_GETDUPLICATEFIELDSFORRECORDSOURCE]
(
@RECORDSOURCEID uniqueidentifier
)
as
set nocount on;
select
[MKTDUPLICATEFIELD].[ID],
[MKTDUPLICATEFIELD].[FIELDNAME],
[MKTDUPLICATEFIELD].[FIELDLENGTH],
[MKTDUPLICATEFIELD].[SEQUENCE]
from
dbo.[MKTDUPLICATEFIELD]
inner join
dbo.[MKTDUPLICATE]
on
[MKTDUPLICATE].[ID] = [MKTDUPLICATEFIELD].[DUPLICATEID]
where
[MKTDUPLICATE].[QUERYVIEWCATALOGID] = @RECORDSOURCEID;
return 0;