[步骤]

                                              select a.SKU,                  STUFF((SELECT ';' + BrowseNodeName                   FROM E_Product_Amazon_BrowseTree b                   WHERE a.sku = b.sku                   AND b.IsMain = 1                  AND b.IsDelete = 0                  FOR XML PATH('')), 1, 1, '') as '平台主类别',                  STUFF((SELECT ';' + BrowseNodeName                   FROM E_Product_Amazon_BrowseTree b                   WHERE a.sku = b.sku                   AND b.IsMain = 0                  AND b.IsDelete = 0                  FOR XML PATH('')), 1, 1, '') as '平台附属类别' from E_Product_Amazon_BrowseTree a with(nolock)                                               where a.sku in (SELECT item FROM dbo.CharSplitForIn('21808740,17567492,16830782,14349234,11150274,3255550,16063232,3624350,14401981,14363184,22783239,5367462,23169748,23153904,23104098,23054607,21997911,21407560,21296514,20150063,17324032,16838143,15916850,15824153,14520285,14491447,13577661,11577433,11407308,11290896,5509887,3355623,3315622,3264246,3211868,3188334,2281925,2279646,22783217,21039420,5855293,20955793,14845360,14755060,7813871,18636828,20955811,14363066,14664548,11299032,23174968,23126597,22795756,21695441,20818066,19673185,19088052,18606568,17835667,17399038,17337041,17199893,17019428,15916728,14966229,14755777,14755776,14716661,14516669,14482511,14444247,14063218,11581793,11558410,9856457,8709039,8442281,8011568,5506556,5421586,5125872,3262854,3190768,2633335,2633273,20845452,19258505,5574053,18080269,15851398,15377609,14332292,17541424,19087682,16751827,14343776,11297146,8709457,3242198,19183825,10061142,5810952,5653947,5523734,17074361,15771810,8795076,8794780,23174962,21763850,21697341,21505740,21176033,21025181,20903527,20254955,19946074,19457353,19352555,19346502,19082158,18788666,17591927,17102758,17079646,17009930,16059386,15784167,15771782,14663362,10568368,8709456,8512929,8298954,8298819,8011046,5688838,3255646,3167014,2853862,2632007,2281368,2198583,16697858,19461380,18819861,17009847,8756493,21395057,18901345,17576072,17199895,15851269,11409703,8029545,3233986,19602932,19061509,16475961,14820069,14471161,23167442,23007937,21485485,20047835,20003796,19499342,19460086,19000312,17988561,17548649,17548592,17160608,17108782,16968689,14736077,14717463,14592904,14087092,11606025,11502746,11499170,11421580,9507643,9354147,8435470,8399625,5195001,5170871,3387960,2853773,1917291,23104055,21083108,19414506,11776244,8293244,2632018,23129740,17684815,14594767,14332317,23113067,21750811,21623021,21177721,20099969,19493896,19183803,18606495,17747881,17488404,17179540,14635697,14602684,13566050,11508390,9354226,8689493,8220801,5879444,5469386,5408874,5262137,5255154,5153258,4496563,3228549,2632012,2207963,23099180,22425142,19757640,18997823,18997815,16475982,14425113,22610374,21731931,21727142,21721294,21697396,21296173,20720126,20556945,19176371,19134963,17437835,17412288,17293408,17283853,15024845,14716212,14505203,14482638,14473140,14171650,11489577,11421603,11346075,8584771,8478088,8293496,8029546,8029381,6283796,3999706,3645294,1917329,21640532,10267782,8029548,5278105,5194501,23098112,22671152,22052743,21578450,21498568,21001972,20899945,20256288,19461699,19257525,19161673,19161645,18600639,17153907,17062585,17008510,16936503,14712965,14664381,14616732,14462477,14414702,13920556,9496277,8509772,8403111,8354953,7984364,7388956,2855154,23162284,21727105,21485424,21456870,21296411,19354069,19177180,19031308,18715437,18001031,17531594,17094073,17062652,16698048,16694548,15824143,14843686,14628635,14483157,14444176,14401874,14363102,14162511,14067971,13956727,11809405,11560761,11443737,8517817,8453623,8261611,5757333,3791924,3355409,1400437,22646077,22610329,21723800,20254995,19633694,19472542,19460101,19273680,19250535,15117922,14752452,14659415,14484971,14456368,14414647,14349215,10678602,10678601,10448387,8237798,5242034,3105817,2073390,22775599,21731995,21407613,19273543,19226150,18819862,17315030,17237496,17066234,15450122,14363185,10568321,10448380,8360730,8291498,8088965,5510838,5503579,3370274,23181827,23159575,23080400,21100793,21062481,20256362,19169061,19166044,18728705,14772840,14425159,14365153,11847731,8264716,5553387,5548722,5503817,23113073,22914839,22795648,22671087,21814331,21696839,21331127,20903529,20358936,20111391,19785258,19546763,19456212,19313016,18944714,18715376,18080204,17324923,17208164,17153117,17079544,17041167,16952434,16857582,16787709,15916973,15450340,14630574,14628487,14456401,14455809,14388065,14276789,14064589,13980478,13888770,11741962,11582070,11294942,11160082,10918544,8495092,7346381,6639059,5528831,5308204,5000459,3519256,3233989,21838826,21182848,21147115,21146428,21071079,19608250,19587391,19166029,19061441,18998229,17481855,17324858,17300570,17181080,17025135,16837983,16784882,14849981,14607902,14588459,14486804,14328361,14063263,13177701,11456103,11368878,8708815,8513311,8274811,7076398,6174991,5737344,5114112,3624375,3478257,3387903,3315608,3148580,23167411,23164258,23164229,23162248,23159846,23159832,23159617,23153816,23144693,23144687,23143807,23143749,23142630,23142588,23141100',','))                                                   and CustomerID=1                                                   and IsDelete=0                                               group by a.sku

应该 添加 and a.CustomerID=? 

[结果]

[期望]