USP_DATALIST_MKTPOSTALTEMPLATE

CREATE procedure dbo.[USP_DATALIST_MKTPOSTALTEMPLATE]
as
  set nocount on;

  select
    [ID],
    [NAME],
    [VALIDATEADDRESSES],
    cast ((case when exists (select top 1 1 from dbo.[MKTEXPORTDEFINITION] where [POSTALTEMPLATEID] = [MKTPOSTALTEMPLATE].[ID]) then 1 else 0 end) as bit) as [INUSE]
  from dbo.[MKTPOSTALTEMPLATE]
  order by [NAME];

  return 0;