CODE:N1408261
Error:14_2627_1_-2146232060
SQL:
                    if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#tbAmazonUploadResultV2IDs') and type='U')
                       drop table #tbAmazonUploadResultV2IDs

                    create table #tbAmazonUploadResultV2IDs
                    (
                     Id int primary key
                    )

                    insert into #tbAmazonUploadResultV2IDs
                    select item as Id from CharSplitForIn(@Ids,',');
                    select v2.[ID],[CustomerID],[OrderSourceID],[FeedSubmissionId],[TemplateID],[Status],[Msg],[AddTime],[AddUserID],[AddUserName],[UpdateTime],[UpdateUserID],[UpdateUserName],[RecommendedBrowseNodeName],[TranslateStatus],[RecommendedBrowseNode],[BrowsePathByID],[Rank],[PlanId],[UploadType]  from  [RB_AmazonUploadResult_V2] (nolock) v2 inner join #tbAmazonUploadResultV2IDs t on v2.ID=t.ID  where v2.CustomerID=1  
PARAMS:@Ids = 48476163,48476164,48476165,48476158,48476159,48476160,48476161,48476162,48476150,48476151,48476152,48476153,48476154,48476155,48476156,48476157,48476147,48476148,48476149,48476144,48476145,48476146,48476133,48476134,48476135,48476136,48476137,48476138,48476139,48476140,48476141,48476142,48476143,48476120,48476121,48476122,48476123,48476124,48476125,48476126,48476127,48476128,48476129,48476130,48476131,48476132,48476109,48476110,48476111,48476112,48476113,48476114,48476115,48476116,48476117,48476118,48476119,48476105,48476106,48476107,48476108,48476096,48476097,48476098,48476099,48476100,48476101,48476102,48476103,48476104,48476087,48476088,48476089,48476090,48476091,48476092,48476093,48476094,48476095,48476076,48476077,48476078,48476079,48476080,48476081,48476082,48476083,48476084,48476085,48476086,48476065,48476066,48476067,48476068,48476069,48476070,48476071,48476072,48476073,48476074,48476075,48476053,48476054,48476055,48476056,48476057,48476058,48476059,48476060,48476061,48476062,48476063,48476064,48476041,48476042,48476043,48476044,48476045,48476046,48476047,48476048,48476049,48476050,48476051,48476052,48476027,48476028,48476029,48476030,48476031,48476032,48476033,48476034,48476035,48476036,48476037,48476038,48476039,48476040,48476014,48476015,48476016,48476017,48476018,48476019,48476020,48476021,48476022,48476023,48476024,48476025,48476026,48476002,48476003,48476004,48476005,48476006,48476007,48476008,48476009,48476010,48476011,48476012,48476013,48475994,48475995,48475996,48475997,48475998,48475999,48476000,48476001,48475990,48475991,48475992,48475993,48475989,48475988,48475987,48475985,48475986,48475983,48475984,48475981,48475982,48475979,48475980,48475970,48475971,48475972,48475973,48475974,48475975,48475976,48475977,48475978,48475967,48475968,48475969,48475966,48473918,48473919,48473920,48473921,48473922,48473923,48473924,48473925,48473926,48473927,48473928,48473929,48473906,48473907,48473908,48473909,48473910,48473911,48473912,48473913,48473914,48473915,48473916,48473917,48473903,48473904,48473905,48473900,48473901,48473902,48473896,48473897,48473898,48473899,48473894,48473895,48473890,48473891,48473892,48473893,48473888,48473889,48473885,48473886,48473887,48473882,48473883,48473884,48473869,48473870,48473871,48473872,48473873,48473874,48473875,48473876,48473877,48473878,48473879,48473880,48473881,48473868,48473867,48473860,48473861,48473862,48473863,48473864,48473865,48473866,48473855,48473856,48473857,48473858,48473859,48473853,48473854,48473849,48473850,48473851,48473852,48473842,48473843,48473844,48473845,48473846,48473847,48473848,48473835,48473836,48473837,48473838,48473839,48473840,48473841,48473820,48473821,48473822,48473823,48473824,48473825,48473826,48473827,48473828,48473829,48473830,48473831,48473832,48473833,48473834,48473809,48473810,48473811,48473812,48473813,48473814,48473815,48473816,48473817,48473818,48473819,48473796,48473797,48473798,48473799,48473800,48473801,48473802,48473803,48473804,48473805,48473806,48473807,48473808,48473783,48473784,48473785,48473786,48473787,48473788,48473789,48473790,48473791,48473792,48473793,48473794,48473795,48473776,48473777,48473778,48473779,48473780,48473781,48473782,48473769,48473770,48473771,48473772,48473773,48473774,48473775,48473763,48473764,48473765,48473766,48473767,48473768,48473755,48473756,48473757,48473758,48473759,48473760,48473761,48473762,48473748,48473749,48473750,48473751,48473752,48473753,48473754,48473742,48473743,48473744,48473745,48473746,48473747,48473732,48473733,48473734,48473735,48473736,48473737,48473738,48473739,48473740,48473741,48473730,48473731,48473425,48473421,48473422,48473423,48473424,48473416,48473417,48473418,48473419,48473420,48473413,48473414,48473415,48473409,48473410,48473411,48473412,48473405,48473406,48473407,48473408,48473403,48473404,48473400,48473401,48473402,48473399,48473396,48473397,48473398,48473390,48473391,48473392,48473393,48473394,48473395,48473382,48473383,48473384,48473385,48473386,48473387,48473388,48473389,48473376,48473377,48473378,48473379,48473380,48473381,48473372,48473373,48473374,48473375,48473369,48473370,48473371,48473364,48473365,48473366,48473367,48473368,48473359,48473360,48473361,48473362,48473363,48473354,48473355,48473356,48473357,48473358,48473350,48473351,48473352,48473353,48473346,48473347,48473348,48473349,48473341,48473342,48473343,48473344,48473345,48473338,48473339,48473340,48473333,48473334,48473335,48473336,48473337,48473329,48473330,48473331,48473332,48473324,48473325,48473326,48473327,48473328,48473318,48473319,48473320,48473321,48473322,48473323,48473312,48473313,48473314,48473315,48473316,48473317,48473308,48473309,48473310,48473311,48473304,48473305,48473306,48473307,48473300,48473301,48473302,48473303,48473296,48473297,48473298,48473299,48473295,48473291,48473292,48473293,48473294,48473289,48473290,48473283,48473284,48473285,48473286,48473287,48473288,48473277,48473278,48473279,48473280,48473281,48473282,48473272,48473273,48473274,48473275,48473276,48473268,48473269,48473270,48473271,48473263,48473264,48473265,48473266,48473267,48473259,48473260,48473261,48473262,48473255,48473256,48473257,48473258,48473251,48473252,48473253,48473254,48473249,48473250,48473248,48473247,48473246,48473245,48473244,48473243,48473242,48473241,48473240,48473239,48473238,48473237,48473236,48473235,48473234,48473233,48473232,48473230,48473231,48473229,48473228,48473227,48473226,48472040,48472041,48472042,48472025,48472026,48472027,48472028,48472029,48472030,48472031,48472032,48472033,48472034,48472035,48472036,48472037,48472038,48472039,48472012,48472013,48472014,48472015,48472016,48472017,48472018,48472019,48472020,48472021,48472022,48472023,48472024,48471998,48471999,48472000,48472001,48472002,48472003,48472004,48472005,48472006,48472007,48472008,48472009,48472010,48472011,48471984,48471985,48471986,48471987,48471988,48471989,48471990,48471991,48471992,48471993,48471994,48471995,48471996,48471997,48471972,48471973,48471974,48471975,48471976,48471977,48471978,48471979,48471980,48471981,48471982,48471983,48471957,48471958,48471959,48471960,48471961,48471962,48471963,48471964,48471965,48471966,48471967,48471968,48471969,48471970,48471971,48471942,48471943,48471944,48471945,48471946,48471947,48471948,48471949,48471950,48471951,48471952,48471953,48471954,48471955,48471956,48471928,48471929,48471930,48471931,48471932,48471933,48471934,48471935,48471936,48471937,48471938,48471939,48471940,48471941,48471913,48471914,48471915,48471916,48471917,48471918,48471919,48471920,48471921,48471922,48471923,48471924,48471925,48471926,48471927,48471899,48471900,48471901,48471902,48471903,48471904,48471905,48471906,48471907,48471908,48471909,48471910,48471911,48471912,48471884,48471885,48471886,48471887,48471888,48471889,48471890,48471891,48471892,48471893,48471894,48471895,48471896,48471897,48471898,48471875,48471876,48471877,48471878,48471879,48471880,48471881,48471882,48471883,48471866,48471867,48471868,48471869,48471870,48471871,48471872,48471873,48471874,48471855,48471856,48471857,48471858,48471859,48471860,48471861,48471862,48471863,48471864,48471865,48471845,48471846,48471847,48471848,48471849,48471850,48471851,48471852,48471853,48471854,48471843,48471844,47662490,47662491,47662489,47662488,47662486,47662487,47662485,47662483,47662482,47662481,47662480,47662479,47662477,47662478,47662475,47662476,47662473,47662474,47662472,47662471,47662469,47662470,47662467,47662468,47662465,47662466,47662464,47662463,47662461,47662462,47662459,47662460,47662458,47662456,47662457,47662454,47662455,47662453,47662452,47662449,47662451,47662447,47662448,47662446,47662443,47662444,47662442,47662440,47662441,47662439,47662438,47662436,47662437,47662435,47662434,47662432,47662431,47662429,47662430,47662428,47662427,47662426,47662424,47662423,47662422,47662421,47662420,47662419,47662418,47662417,47662416,47662415,47662414,47662413,47662411,47662412,47662410,47662409,47662407,47662408,47662406,47662405,47662403,47662404,47662402,47662401,47662400,47662399,47662397,47662398,47662396,47662394,47662395,47662393,47662391,47662392,47662390,47662389,47662387,47662388,47662386,47662384,47662385,47662383,47662382,47662381,47662380,47662379,47662378,47662377,47662376,47662374,47662375,47662373,47662371,47662372,47662370,47662369,47662367,47662366,47662365,47662364,47662362,47662363,47662361,47662360,47662358,47662359,47662357,47662356,47662355,47662353,47662352,47662350,47662351,47662349,47662348,47662347,47662346,47662345,47662343,47662342,47662341,47662340,47662339,47662337,47662336,47662335,47662334,47662333,47662332,47662331,47662330,47662329,47662328,47662327,47662326,47662325,47662324,47662323,47662322,47662321,47662320,47662319,47662318,47662317,47662315,47662314,47662313,47662312,47662311,47662310,47662309,47662308,47662307,47662306,47662305,47662304,47662303,47662302,47662301,47662300,47662299,47662298,47662297,47662296,47662295,47662294,47662293,47662292,47662290,47662289,47662288,47661578,47661579,47661580,47661581,47661565,47661566,47661567,47661568,47661569,47661570,47661571,47661572,47661573,47661574,47661575,47661576,47661577,47661554,47661555,47661556,47661557,47661558,47661559,47661561,47661562,47661563,47661564,47661545,47661546,47661547,47661548,47661549,47661550,47661551,47661552,47661553,47661537,47661538,47661539,47661540,47661541,47661542,47661543,47661544,47661530,47661531,47661532,47661533,47661534,47661535,47661536,47661525,47661526,47661527,47661528,47661529,47661521,47661522,47661524,47661519,47661520,47661514,47661515,47661516,47661517,47661518,47661513,47661512,47661510,47661511,47661507,47661509,47661500,47661501,47661502,47661503,47661504,47661505,47661506,47661492,47661493,47661494,47661495,47661496,47661497,47661498,47661499,47661485,47661486,47661487,47661488,47661489,47661490,47661491,47661476,47661477,47661478,47661479,47661480,47661481,47661482,47661483,47661484,47661466,47661467,47661468,47661470,47661471,47661472,47661473,47661474,47661475,47661457,47661458,47661459,47661460,47661461,47661462,47661464,47661465,47661448,47661449,47661450,47661451,47661452,47661453,47661454,47661455,47661456,47661443,47661444,47661445,47661446,47661447,47661434,47661435,47661436,47661437,47661438,47661439,47661440,47661441,47661442,47661426,47661427,47661428,47661429,47661430,47661431,47661432,47661433,47661419,47661420,47661421,47661422,47661423,47661424,47661425,47661418,47661417,47661416,47661415,47661414,47661413,47661412,47661411,47661410,47661409,47661408,47661407,47661406,47661405,47661403,47661404,47661400,47661401,47661402,47661394,47661395,47661396,47661398,47661399,47661388,47661389,47661390,47661391,47661392,47661393,47661383,47661384,47661385,47661386,47661387,47333954,47333952,47333951,47333948,47333947,47333946,47333934,47333933,47333931,47333929,47333925,47051004,47051004,47049143,47049143,47049142,47049142,47049138,47049138,47049136,47049136,47049128,47049128,47049121,47049121,47049118,47049118,47049115,47049115,47049112,47049112,47049109,47049109,47049101,47049101,47049098,47049098,47049089,47049089,47049078,47049078,46868049,46868046,46868044,46868041,46868038,46868036,46868035,46868034,46868029,46868028,46868026,46868023,46833793,46833793,46833791,46833791,46833786,46833786,46833784,46833784,46833783,46833783,46833781,46833781,46833780,46833780,46833779,46833779,46833778,46833778,46833777,46833777,46833774,46833774,46833772,46833772,46833771,46833771,46704912,46704912,46704906,46704906,46704905,46704905,46704901,46704901,46704900,46704898,46704898,46704897,46704897,46704896,46704896,46704895,46704895,46704892,46704892,46704891,46704891,46704890,46704890,46158618,46158618,46158610,46158610,46158606,46158606,46158597,46158597,46158593,46158593,46158590,46158590,46158582,46158582,46158579,46158579,46158574,46158574,46158571,46158571,46158568,46158568,46158567,46158567,46158563,46158563,46158562,46158562,46158557,46158557,46158554,46158554,46117573,46117573,46117568,46117568,46117564,46117564,46117559,46117559,46117556,46117556,46117550,46117550,46117547,46117547,46117543,46117543,46117540,46117540,46117538,46117538,46117532,46117532,46117529,46117529,46117526,46117526,46117521,46117521,46117518,46117518,46079840,46079833,46079832,46079830,46079828,46079827,46079823,46079822,46079819,46079818,46079814,46043624,46043622,46043621,46043618,46043617,46043615,46043613,46043611,46043609,46043606,46043604,46043602 ,
MESSAGE:Violation of PRIMARY KEY constraint 'PK__#tbAmazo__3214EC071DEDC41D'. Cannot insert duplicate key in object 'dbo.#tbAmazonUploadResultV2IDs'. The duplicate key value is (47051004).
The statement has been terminated.

未去重，有重复值，或者临时表不用主键。