spGetXListFieldData

            CREATE PROCEDURE [dbo].[spGetXListFieldData]
            @LISTID int,
            @XMLRecordIDs ntext

            as

            DECLARE @idoc int
            --sterling CR294649-022708
            --fnGetCurrentSystemUser dropped
            --declare @CURRENT_SYSTEM_USER nvarchar(30)

            --SET @CURRENT_SYSTEM_USER = [dbo].fnGetCurrentSystemUser();

            CREATE TABLE #TableIDS (BORecID int)

            EXEC sp_xml_preparedocument @idoc OUTPUT, @XMLRecordIDs

                INSERT INTO #TableIDS
                SELECT [ID] FROM OPENXML (@idoc, '/DS/BOIDS', 2)
                WITH ([ID] int)

            EXEC sp_xml_removedocument @idoc

            DECLARE @SQL nvarchar(4000)
            DECLARE @TABLENAME nvarchar(128);
            DECLARE @XMLData table([BackOfficeID] int) 

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

            SET @SQL = 'SELECT ml.BB_XListRecordID, xl.* FROM ' --+ @CURRENT_SYSTEM_USER + '.' 
                        + @TABLENAME + ' xl inner join EmailListUploadMasterList ml
                        on xl.BB_XListRecordGuid = ml.GUID INNER JOIN #TableIDS xmlRecIds on ml.BB_XListRecordID
                        = xmlRecIds.BORecID'

            exec(@SQL)

            DROP TABLE #TableIDS