spGetLinkedClientUsersFromBackOfficeIDs

            CREATE PROCEDURE dbo.spGetLinkedClientUsersFromBackOfficeIDs
            (
            @REIDs nvarchar(4000),
            @EEIDs nvarchar(4000)
            )
            AS
            BEGIN
                SELECT cu.ID, cu.UserName
                FROM dbo.ClientUsers cu
                INNER JOIN dbo.BackOfficeSystemUsers bosu ON cu.ID = bosu.ClientUsersID and bosu.[current] = 1 and cu.Deleted = 0
                INNER JOIN dbo.BackOfficeSystemPeople bosp ON bosp.ID = bosu.BackofficePeopleID and bosp.BackOfficeSystemID = 0
                INNER JOIN dbo.fnCSVIDsToTable(@REIDs) ids ON ids.ID = bosp.BackOfficeRecordID

                UNION

                SELECT cu.ID, cu.UserName
                FROM dbo.ClientUsers cu
                INNER JOIN dbo.BackOfficeSystemUsers bosu ON cu.ID = bosu.ClientUsersID and bosu.[current] = 1 and cu.Deleted = 0
                INNER JOIN dbo.BackOfficeSystemPeople bosp ON bosp.ID = bosu.BackofficePeopleID and bosp.BackOfficeSystemID = 1
                INNER JOIN dbo.fnCSVIDsToTable(@EEIDs) ids ON ids.ID = bosp.BackOfficeRecordID
            END