SELECT
ProductionKanbanID,
value
FROM
Ware_ProductionKanban
CROSS APPLY STRING_SPLIT(ProcessLine_Id, ',')
)
SELECT
SV.ProductionKanbanID,
Base_ProcessLine.ProcessLine_Id,
Base_ProcessLine.ProcessLineName
FROM
SplitValues AS SV
INNER JOIN
Base_ProcessLine ON CAST(Base_ProcessLine.ProcessLine_Id AS NVARCHAR(MAX)) = SV.value;
我的数据字典
) SELECT SV.ProductionKanbanID, Base_ProcessLine.ProcessLine_Id, Base_ProcessLine.ProcessLineName FROM SplitValues AS SV INNER JOIN Base_ProcessLine ON CAST(Base_ProcessLine.ProcessLine_Id AS NVARCHAR(MAX)) = SV.value;