USP_EMAILLIST_CREATEUPLOADEMAILTABLEINDEX

create procedure dbo.USP_EMAILLIST_CREATEUPLOADEMAILTABLEINDEX
(
    @LISTID int
    ) WITH EXECUTE AS OWNER
    as
BEGIN
    set nocount on;

    declare @TABLENAME nvarchar(128);
    declare @EMAILADDRESSFIELD nvarchar(128)
    declare @EMAILADDRESSDISPLAYNAMEFIELD nvarchar(128)

    set @TABLENAME = dbo.fnUloadedListBuildTableName(@LISTID);

    SELECT @EMAILADDRESSFIELD =[EmailAddressFieldName], @EMAILADDRESSDISPLAYNAMEFIELD = EmailDisplayNameFieldName 
    FROM dbo.EmailList 
    WHERE [ID] = @ListID

    declare @SQL nvarchar(MAX);

    set @SQL = 'create index ' + @TABLENAME + '__GUID__EmailDisplayName on ' + @TABLENAME + ' ([BB_XListRecordGuid],[' + @EMAILADDRESSDISPLAYNAMEFIELD + '])'

    exec (@SQL);

    set @SQL = 'create index ' + @TABLENAME + '__BB_XListSequence__Email on ' + @TABLENAME + ' ([BB_XListSequence],[' + @EMAILADDRESSFIELD + '])'

    exec (@SQL);

    set @SQL = 'create index ' + @TABLENAME + '__EmailAddress on ' + @TABLENAME + ' ([' + @EMAILADDRESSFIELD + '])'

    exec (@SQL);

    return 0;
end