USP_DATALIST_MKTCOMMUNICATIONEFFORTWITHOUTTEMPLATESEEDS

create procedure dbo.USP_DATALIST_MKTCOMMUNICATIONEFFORTWITHOUTTEMPLATESEEDS
(
  @SEGMENTATIONID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier
)
as
  set nocount on;

  declare @RESULTS table (
    [ID] uniqueidentifier, 
    [SEEDID] uniqueidentifier,
    [NAME] nvarchar(max),
    [ADDRESSBLOCK] nvarchar(300),
    [PHONENUMBER] nvarchar(100),
    [EMAILADDRESS] nvarchar(100),
    [LOCKED] bit,
    [LOCKEDIMAGE] nvarchar(max),
    [IMAGEKEY] nvarchar(max),
    [ORDERBY] int identity(1,1) -- to insure we sort correctly when this datalist does its output

  ); 

  insert into @RESULTS
  exec dbo.[USP_DATALIST_MKTCOMMUNICATIONEFFORTSEEDS] @SEGMENTATIONID, @CURRENTAPPUSERID;

  select
    [ID],
    [SEEDID],
    [NAME],
    [ADDRESSBLOCK],
    [PHONENUMBER],
    [EMAILADDRESS]
  from
    @RESULTS
  order by
    [ORDERBY];

  return 0;