
我的数据字典
WITH SplitValues AS (
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;