select ‘‘‘‘+SUBSTRING( b.id,2,len(b.id))+‘‘‘‘ from ( select (stuff(( select ‘‘‘,‘‘‘ +t.sysserialno from ( select * from sdshippkitem where orderno = ‘0200186943‘ ) t for xml path(‘‘)),1,1,‘‘)) id) b
2022-08-20 07:52:26
select ‘‘‘‘+SUBSTRING( b.id,2,len(b.id))+‘‘‘‘ from ( select (stuff(( select ‘‘‘,‘‘‘ +t.sysserialno from ( select * from sdshippkitem where orderno = ‘0200186943‘ ) t for xml path(‘‘)),1,1,‘‘)) id) b