Skip to content

请问大佬,一张表有两个下拉框一个Select多选和checkbox,修改的时候checkbox要显示新增Select多选的数据,怎么查询Select多选的数据 #356

@99tian

Description

@99tian

微信图片编辑_20240719172933
我的数据字典

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;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions