在游标SELECT语句中使用变量

I've written a stored procedure that will take a parent part, go through the bill-of-materials records for that part and conditionally concatenate matching child-records (i.e. the parts which are included in this part's BOM), but only child-records that meet certain criteria (using our naming convention, anything starting with '.', 'E', or 'ZG').I've written a stored procedure that will take