UFN_MKTSPONSORSHIPMAILINGTEMPLATESEED_GETSEEDS

create function dbo.[UFN_MKTSPONSORSHIPMAILINGTEMPLATESEED_GETSEEDS]
(
  @SPONSORSHIPMAILINGTEMPLATEID uniqueidentifier
)
returns table
as
  return 
  (
    select 
      [MKTSEED].[ID],
      (case when [MKTSPONSORSHIPMAILINGTEMPLATESEED].[ID] is null then 0 else 1 end) as [SELECTED],
      [MKTSEED].[INACTIVE],
      [TITLECODE].[DESCRIPTION] as [TITLE],
      [MKTSEED].[FIRSTNAME],
      [MKTSEED].[MIDDLENAME],
      [MKTSEED].[LASTNAME],
      [SUFFIXCODE].[DESCRIPTION] as [SUFFIX],
      [COUNTRY].[ABBREVIATION] as [COUNTRY],
      [MKTSEED].[ADDRESSBLOCK],
      [MKTSEED].[CITY],
      [STATE].[ABBREVIATION] as [STATE],
      [MKTSEED].[POSTCODE],
      [MKTSEED].[CART],
      [MKTSEED].[DPC],
      [MKTSEED].[LOT],
      [MKTSEED].[PHONENUMBER],
      [MKTSEED].[EMAILADDRESS],
      dbo.[UFN_TRANSLATIONFUNCTION_SITE_GETNAME]([MKTSEED].[SITEID]) as [SITE]
    from dbo.[MKTSEED]
    left outer join dbo.[MKTSPONSORSHIPMAILINGTEMPLATESEED] on dbo.[MKTSPONSORSHIPMAILINGTEMPLATESEED].[SEEDID] = dbo.[MKTSEED].[ID] and [MKTSPONSORSHIPMAILINGTEMPLATESEED].[SPONSORSHIPMAILINGTEMPLATEID] = @SPONSORSHIPMAILINGTEMPLATEID
    left outer join dbo.[TITLECODE] on [MKTSEED].[TITLECODEID] = [TITLECODE].[ID]
    left outer join dbo.[SUFFIXCODE] on [MKTSEED].[SUFFIXCODEID] = [SUFFIXCODE].[ID]
    left outer join dbo.[COUNTRY] on [MKTSEED].[COUNTRYID] = [COUNTRY].[ID]
    left outer join dbo.[STATE] on [MKTSEED].[STATEID] = [STATE].[ID]
    where ([MKTSEED].[INACTIVE] = 0 or [MKTSPONSORSHIPMAILINGTEMPLATESEED].[ID] is not null)
  );