逗号隔开一行 变 多行

    //    t_ClueInfo clue = t_ClueInfo.Get(this.Id);
    //    string sql = "select * from jw_Subject where fId "+
           "in(SELECT RESUTLTB.value('.', 'VARCHAR(50)') AS fId FROM "
           +"t_ClueInfo A CROSS APPLY "
           +"(SELECT fName, CAST('<ROW>' + REPLACE(fYXKeMuIds, ',', '</ROW><ROW>') + '</ROW>' AS XML) AS XMLCODE) C1 "
           +" CROSS APPLY XMLCODE.nodes('*') T (RESUTLTB)  where fId="+clue.fId+")";