USP_MKTEXPORTDEFINITION_LOAD

CREATE procedure dbo.[USP_MKTEXPORTDEFINITION_LOAD]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    [NAME],
    [MAILINGTYPECODE],
    [POSTALEXPORT],
    [POSTALTEMPLATEID],
    [PREVIEWDATALISTCATALOGID],
    [NETCOMMUNITYDATASOURCEID],
    convert(bit, case when exists(select 1 from dbo.[MKTPOSTALTEMPLATE]) then 1 else 0 end) as [HASPOSTALTEMPLATES],
    dbo.[UFN_MKTNETCOMMUNITYINTEGRATION_LINKESTABLISHED]() as [NETCOMMUNITYLINKESTABLISHED],
    convert(bit, case when exists (select top 1 1 from dbo.[LETTERCODE] where [MKTEXPORTDEFINITIONID] = @ID and [WORDFILE] is not null) then 1 else 0 end) as [INUSEBYMERGEDOCUMENT],
    [CHANGEDBYCULTURE],
    [TSLONG],
    [ISSYSTEM]
  from dbo.[MKTEXPORTDEFINITION]
  where [ID] = @ID;

  return 0;