UFN_MKTEXPORTDEFINITION_GETSPECIALQUERYVIEWIDS

Returns a table of all the special export query view IDs.

Return

Return Type
table

Definition

Copy



CREATE function dbo.[UFN_MKTEXPORTDEFINITION_GETSPECIALQUERYVIEWIDS]()
returns table
as
  return
  (
    select
      cast('B453E917-6B30-4B7C-B83A-E3444B18A318' as uniqueidentifier) as [ID]  /* Mailing fields query */
    union
    select
      cast('D67B643B-F31A-4A6A-88DD-5992DD670D26' as uniqueidentifier) as [ID]  /* Acknowledgement fields query */
    union
    select
      cast('9F53CBCB-D763-433F-BD82-F95A019250BE' as uniqueidentifier) as [ID]  /* Postal USA fields */
    union
    select
      cast('83B1C065-3D9C-4AD5-B578-12BE907E9450' as uniqueidentifier) as [ID]  /* Postal UK fields */
    union
    select
      cast('CDD0B514-5258-4CCD-A224-A816C10F9F05' as uniqueidentifier) as [ID] /* Postal CA fields */
  );