select new_name,new_code,new_multipleselection,multipleselection.name 
from new_attachment
outer apply fn_GetPickListNameByMultiple(‘new_attachment‘,‘new_multipleselection‘,new_multipleselection,1033)  multipleselection

USE [***_MSCRM]
GO
 
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
CREATE FUNCTION [dbo].[fn_GetPickListNameByMultiple] 
(
  @entityName NVARCHAR(200)
, @fieldName NVARCHAR(200)
, @fieldValue NVARCHAR(200)
, @langId int
)
RETURNS @MultiTable TABLE 
(
[name] nvarchar(max)
)
AS
begin
DECLARE @CurrentIndex int;
     DECLARE @NextIndex int;
     SELECT @CurrentIndex=1;
DECLARE @Text nvarchar(max);
DECLARE @ReturnText nvarchar(max)
DECLARE @value nvarchar(max)
set @ReturnText=‘‘;
set @value=‘‘;
set @fieldValue=replace(replace(@fieldValue,‘[‘,‘‘),‘]‘,‘‘)
WHILE(@CurrentIndex<=len(@fieldValue))
         BEGIN
             SELECT @NextIndex=charindex(‘,‘,@fieldValue,@CurrentIndex);
             IF(@NextIndex=0 OR @NextIndex IS NULL)
                 SELECT @NextIndex=len(@fieldValue)+1;
                 SELECT @Text=substring(@fieldValue,@CurrentIndex,@NextIndex-@CurrentIndex);
if(@Text<>-1)
begin
SELECT DISTINCT 
 @value=sm.value
FROM   entity e
INNER JOIN stringmap sm
ON e.objecttypecode = sm.objecttypecode AND
  sm.attributename = @fieldName AND sm.AttributeValue = @Text
  AND sm.LangId=@langId
WHERE  e.OverwriteTime=0 AND e.Name = @entityName
set @ReturnText=@ReturnText+@value+‘,‘;
end
                 SELECT @CurrentIndex=@NextIndex+1;
             END
if(isnull(@fieldValue,‘‘)=‘‘)
begin
INSERT INTO @MultiTable([name]) VALUES(null)
end
else
begin
INSERT INTO @MultiTable([name]) VALUES(substring(@ReturnText,1,len(@ReturnText)-1))
end
RETURN 
end
GO