At the front desk code:
Code background:
Var result=await executeHelper. SearchAsync
(" SELECT STUFF ((SELECT the ', '+ SRC_ORDER FROM V_MFT_APSProductionOrder where PATINDEX (',' + RTRIM (PO_ID) + '%', ', '+ a.E RPWorkOrder +', ') & gt; Zero ORDER BY PATINDEX (' % '+ RTRIM (PO_ID) +' % ', ', '+ a.E RPWorkOrder +', ') FOR XML PATH (' ')), 1, 1, ' ') as ConsolidationSourceWorkOrder FROM (select distinct stuff ((select ', '+ ERPWorkOrder FROM V_MFT_SizingInfo where MatId=arjun atId FOR XML PATH ('')), 1, 1, ' ') as ERPWorkOrder FROM V_MFT_SizingInfo as a where clause arjun atId='" + workOrderInfo. MatId + "") as a" new Dictionary ());
WorkOrderInfo. ConsolidationSourceWorkOrder=result. FirstOrDefault ();
//*/