CODE:N1151561
Error:11_-2_0_-2146232060
SQL: if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#tb_Amazon_OrderSourceIDs') and type='U'))
drop table #tb_Amazon_OrderSourceIDs
create table #tb_Amazon_OrderSourceIDs (Id int primary key)
insert into #tb_Amazon_OrderSourceIDs
SELECT CONVERT(INT, item) as Id FROM Charsplitforin('13331,13330,13295,13267,13258,13257,13229,13228,13226,13223,13222,13221,13220,13219,13218,13217,13215,13201,13200,13199,13195,13194,13191,13188,13187,13174,13173,13172,13171,13170,13168,13167,13159,13155,13154,13153,13151,13149,13148,13147,13146,13145,13144,13142,13140,13138,13137,13136,13135,13134,13133,13132,13131,13124,13123,13120,13117,13116,13115,13114,13113,13105,13104,13103,13102,13101,13100,13099,13098,13091,13090,13087,13084,13083,13082,13080,13076,13075,13074,13073,13072,13071,13070,13069,13046,13045,13044,13042,13038,13028,13027,13026,13025,13023,13020,13019,13018,13017,13016,12983,12982,12977,12972,12971,12925,12924,12921,12918,12917,12916,12915,12914,12815,12814,12813,12812,12810,12809,12808,12786,12785,12782,12780,12779,12778,12777,12776,12775,12768,12766,12764,12763,12761,12749,12748,12747,12746,12745,12744,12742,12741,12740,12739,12706,12705,12702,12699,12698,12697,12696,12695,12691,12690,12687,12685,12684,12683,12682,12681,12680,12639,12638,12637,12636,12631,12629,12628,12627,12611,12610,12591,12566,12565,12561,12559,12558,12557,12556,12555,12554,12546,12545,12544,12530,12496,12495,12492,12490,12488,12487,12486,12485,12476,12475,12474,12473,12468,12467,12466,12465,12463,12013,12012,12010,12009,12003,12002,12001,11993,11992,11991,11975,11973,11971,11970,11969,11966,11965,11964,11962,11961,11959,11952,11946,11944,11934,11903,11902,11899,11898,11897,11893,11892,11891,11890,11889,11888,11887,11885,11884,11883,11881,11880,11875,11874,11873,11872,11871,11870,11868,11867,11866,11865,11862,11861,11860,11859,11858,11857,11856,11855,11854,11852,11851,11848,11840,11839,11838,11837,11836,11835,11834,11833,11832,11831,11830,11828,11826,11825,11824,11823,11822,11821,11820,11818,11817,11800,11798,11795,11794,11793,11792,11790,11789,11759,11758,11757,11756,11745,11742,11741,11738,11731,11727,11726,11725,11724,11723,11722,11721,11715,11713,11712,11710,11709,11708,11706,11703,11702,11683,11682,11681,11680,11679,11678,11677,11676,11674,11672,11651,11650,11648,11647,11646,11645,11644,11638,11637,11625,11624,11622,11621,11620,11616,11613,11612,11611,11610,11608,11607,11606,11605,11604,11603,11601,11597,11596,11595,11594,11584,11583,11582,11579,11576,11572,11571,11570,11569,11568,11567,11566,11565,11564,11558,11557,11555,11552,11551,11550,11548,11544,11543,11541,11540,11537,11536,11532,11526,11525,11524,11522,11521,11513,11510,11509,11508,11507,11506,11505,11504,11499,11498,11497,11496,11495,11494,11493,11491,11490,11489,11488,11487,11486,11485,11484,11483,11482,11481,11480,11479,11478,11477,11476,11475,11474,11473,11472,11471,11470,11469,11468,11466,11464,11463,11462,11461,11450,11449,11441,11440,11439,11438,11437,11435,11434,11428,11427,11426,11425,11424,11423,11422,11421,11407,11406,11405,11404,11401,11400,11399,11398,11394,11393,11392,11391,11390,11389,11388,11387,11365,11363,11362,11359,11357,11351,11344,11340,11338,11336,11335,11330,11329,11328,11327,11326,11325,11324,11323,11322,11318,11317,11316,11311,11307,11302,11301,11296,11292,11291,11289,11285,11284,11283,11282,11281,11280,11279,11278,11277,11276,11272,11267,11264,11263,11261,11259,11258,11257,11256,11255,11249,11248,11246,11243,11242,11239,11234,11232,11231,11230,11229,11228,11227,11226,11213,11211,11210,11207,11206,11205,11204,11203,11202,11201,11198,11194,11192,11190,11188,11187,11186,11185,11183,11181,11180,11179,11178,11176,11171,11170,11169,11168,11167,11166,11164,11161,11160,11158,11157,11156,11155,11154,11151,11147,11146,11143,11142,11141,11139,11138,11137,11136,11135,11134,11133,11132,11131,11130,11129,11128,11126,11124,11123,11122,11120,11118,11116,11115,11113,11112,11111,11110,11108,11102,11100,11098,11097,11096,11095,11094,11093,11092,11091,11090,11089,11088,11086,11085,11084,11051,11034,11022,11021,11018,11016,11015,11010,10994,10992,10991,10990,10989,10988,10986,10981,10979,10978,10977,10976,10975,10972,10971,10970,10965,10960,10954,10953,10952,10929,10928,10927,10926,10922,10921,10920,10919,10918,10917,10916,10914,10912,10911,10910,10909,10908,10905,10902,10901,10900,10899,10898,10897,10896,10895,10894,10893,10892,10891,10890,10889,10879,10878,10876,10875,10874,10873,10871,10870,10868,10867,10866,10865,10864,10863,10862,10861,10859,10858,10855,10854,10853,10851,10850,10849,10848,10847,10846,10845,10844,10837,10835,10827,10826,10818,10814,10812,10809,10804,10801,10799,10773,10772,10771,10770,10769,10768,10767,10766,10765,10764,10763,10758,10757,10754,10753,10751,10749,10748,10746,10745,10744,10743,10737,10717,10710,10709,10708,10567,10565,10560,10558,10556,10555,10554,10551,10550,10549,10548,10547,10543,10542,10541,10540,10539,10538,10537,10536,10535,10534,10533,10532,10531,10530,10529,10528,10527,10526,10525,10524,10496,10485,10467,10453,10450,10433,10430,10429,10428,10427,10424,10420,10414,10398,10397,10395,10387,10386,10382,10381,10380,10378,10375,10374,10367,10366,10365,10364,10361,10360,10359,10358,10357,10356,10355,10353,10351,10350,10349,10348,10347,10346,10345,10344,10343,10336,10330,10329,10327,10320,10319,10318,10317,10316,10315,10313,10312,10311,10310,10309,10308,10292,10291,10290,10289,10288,10285,10284,10283,10281,10280,10278,10265,10264,10263,10256,10254,10253,10252,10251,10247,10246,10245,10230,10187,10138,10137,10106,10095,10094,10088,10087,10084,10083,10082,10081,10080,10079,10075,10074,10073,10072,10071,10070,10069,10068,10067,10066,10065,10064,10063,10062,10061,10059,10054,10053,10050,10049,10048,10047,10046,10045,10043,10036,10034,10033,10030,10029,10028,10027,10024,10023,10022,10008,10007,10006,10005,10004,10003,10002,10001,9968,9966,9965,9961,9959,9958,9957,9956,9952,9950,9949,9928,9927,9924,9922,9921,9920,9919,9918,9916,9915,9914,9913,9910,9908,9905,9903,9892,9891,9890,9889,9888,9887,9886,9885,9884,9882,9881,9877,9876,9875,9874,9873,9872,9871,9870,9869,9868,9867,9866,9865,9863,9862,9861,9860,9859,9858,9857,9855,9854,9853,9852,9851,9850,9839,9838,9837,9836,9835,9834,9833,9832,9831,9830,9829,9828,9827,9826,9825,9824,9823,9822,9821,9817,9816,9810,9807,9806,9805,9804,9801,9800,9799,9792,9788,9787,9786,9785,9782,9781,9780,9777,9776,9775,9773,9772,9771,9770,9768,9767,9766,9748,9714,9713,9712,9711,9705,9703,9702,9701,9700,9698,9697,9696,9695,9694,9693,9692,9691,9690,9679,9670,9669,9664,9663,9662,9661,9654,9653,9652,9651,9650,9649,9648,9647,9645,9643,9641,9640,9626,9624,9623,9622,9618,9617,9616,9615,9614,9613,9612,9611,9610,9608,9606,9605,9604,9603,9602,9600,9598,9597,9596,9594,9593,9592,9589,9588,9587,9585,9583,9582,9580,9579,9578,9577,9572,9568,9567,9566,9565,9562,9557,9556,9555,9554,9553,9551,9550,9548,9547,9546,9545,9544,9536,9535,9534,9533,9532,9531,9529,9528,9526,9525,9524,9523,9522,9503,9496,9495,9494,9493,9492,9491,9490,9489,9488,9487,9486,9484,9483,9482,9481,9480,9479,9478,9477,9476,9475,9470,9469,9468,9467,9466,9460,9459,9458,9457,9456,9455,9454,9453,9452,9451,9450,9449,9448,9447,9440,9439,9438,9437,9436,9428,9426,9425,9423,9422,9421,9420,9419,9417,9416,9415,9414,9412,9407,9406,9380,9379,9364,9363,9362,9361,9303,9302,9301,9300,9298,9297,9296,9295,9294,9293,9292,9291,9290,9289,9288,9287,9286,9285,9284,9283,9272,9271,9258,9257,9237,9236,9235,9226,9225,9224,9223,9222,9219,9218,9217,9216,9215,9211,9210,9209,9208,9207,9206,9205,9176,9175,9174,9173,9172,9171,9170,9169,9168,9167,9161,9160,9159,9158,9157,9155,9154,9153,9152,9150,9149,9148,9147,9146,9140,9139,9138,9137,9136,9130,9129,9128,9127,9126,9125,9124,9123,9121,9120,9119,9118,9117,9114,9113,9112,9108,9107,9099,9098,9097,9090,9089,9088,9087,9086,9085,9084,9083,9082,9080,9079,9078,9077,9074,9070,9069,9068,9067,9066,9061,9057,9047,9040,9039,9038,9037,9036,9033,9032,9031,9030,9029,9028,9027,9021,9010,8990,8989,8959,8958,8957,8956,8955,8947,8930,8928,8927,8926,8925,8924,8862,8861,8860,8859,8858,8857,8856,8855,8854,8853,8852,8851,8841,8838,8696,8695,8694,8693,8692,8679,8677,8676,8674,8640,8639,8637,8636,8621,8620,8619,8618,8616,8615,8614,8612,8611,8609,8606,8605,8570,8565,8564,8563,8559,8558,8557,8556,8552,8543,8522,8519,8518,8517,8511,8505,8501,8499,8498,8496,8495,8494,8493,8492,8491,8490,8487,8485,8477,8476,8475,8474,8473,8472,8471,8465,8463,8462,8461,8460,8458,8457,8456,8455,8446,8437,8428,8414,8413,8412,8411,8410,8405,8403,8393,8390,8382,8381,8380,8379,8378,8377,8376,8366,8357,8353,8351,8350,8349,8348,8347,8346,8345,8336,8260,8259,8258,8257,8256,8255,8254,8253,8252,8251,8250,8249,8248,8247,8246,8245,8244,8243,8242,8157,8155,8151,8149,8147,8140,8137,8131,8126,8125,8124,8123,8122,8119,8118,8116,8114,8113,8112,8111,8101,8099,8098,8097,8096,8095,8094,8093,8092,8078,8077,8076,8075,8074,8073,8072,8071,8070,8059,8058,8057,8056,8039,8037,8036,8034,8033,8031,8024,8023,8018,8017,8013,8012,8011,8010,8002,8001,8000,7999,7998,7997,7996,7980,7979,7978,7977,7976,7956,7955,7954,7953,7950,7948,7945,7942,7936,7935,7934,7933,7932,7931,7930,7929,7928,7927,7926,7925,7924,7923,7922,7905,7904,7903,7902,7901,7900,7898,7897,7893,7892,7891,7890,7760,7759,7755,7754,7753,7752,7751,7749,7740,7739,7721,7720,7719,7714,7713,7712,7711,7710,7708,7707,7706,7704,7702,7698,7521,7519,7518,7517,7516,7515,7514,7513,7512,7511,7443,7442,7398,7397,7396,7395,7394,7392,7391,7389,7386,7383,7382,7379,7378,7377,7376,7375,7369,7368,7367,7366,7364,7363,7362,7361,7360,7359,7298,7297,7296,7289,7198,7192,7175,7170,7169,7168,7167,7166,7165,7164,7163,7162,7160,7159,7158,7157,7121,7119,7116,6964,6963,6960,6955,6954,6953,6952,6951,6950,6949,6941,6940,6939,6938,6937,6935,6934,6933,6932,6931,6930,6929,6928,6927,6926,6925,6924,6923,6922,6921,6919,6918,6917,6916,6915,6912,6911,6910,6909,6908,6907,6906,6904,6903,6902,6901,6899,6895,6891,6890,6888,6887,6885,6884,6883,6882,6869,6837,6835,6809,6808,6807,6777,6756,6755,6754,6702,6701,6700,6698,6697,6696,6691,6690,6689,6688,6687,6675,6674,6673,6672,6671,6670,6669,6660,6659,6658,6652,6646,6645,6644,6643,6642,6641,6640,6639,6638,6625,6623,6622,6621,6620,6619,6618,6616,6615,6614,6613,6611,6607,6599,6598,6596,6594,6593,6592,6591,6585,6574,6573,6572,6571,6570,6564,6563,6561,6559,6558,6556,6555,6554,6516,6515,6514,6513,6510,6507,6499,6485,6484,6479,6464,6439,6438,6436,6433,6400,6399,6381,6275,6268,6267,6265,6264,6263,6260,6238,6237,6236,6228,6173,6159,6158,6157,6156,6155,6154,6153,6151,6150,6149,6148,6146,6144,6143,6142,6140,6139,6137,6123,6116,6115,6114,6113,6112,6111,6110,6109,6108,6107,6106,6105,6104,6102,6101,6100,6099,6098,6097,6096,6095,6094,6093,6092,6090,6088,6087,6086,6085,6084,6082,6081,6080,6079,6078,6077,6076,6075,6073,6072,6071,6070,6069,6068,6067,6063,6062,6061,6060,6057,6056,6055,6054,6051,6050,6049,6043,6042,6041,6039,6031,6030,6029,6028,6027,6026,6025,6024,6023,5955,5954,5953,5952,5949,5948,5946,5944,5813,5809,5783,5781,5780,5779,5777,5776,5774,5773,5771,5770,5769,5768,5767,5766,5764,5754,5753,5751,5750,5749,5748,5747,5746,5745,5744,5743,5742,5741,5740,5738,5734,5733,5716,5714,5712,5711,5706,5705,5691,5685,5684,5679,5675,5673,5672,5671,5670,5669,5668,5666,5665,5664,5663,5661,5660,5657,5647,5645,5641,5640,5637,5636,5635,5634,5633,5632,5631,5628,5627,5626,5625,5610,5609,5608,5607,5606,5605,5603,5587,5586,5585,5582,5581,5580,5579,5578,5577,5576,5575,5574,5573,5572,5571,5570,5568,5567,5566,5565,5564,5563,5556,5553,5552,5537,5534,5533,5515,5514,5505,5504,5486,5485,5482,5481,5478,5477,5475,5473,5472,5471,5470,5469,5468,5467,5466,5465,5464,5463,5462,5461,5460,5457,5456,5454,5452,5451,5446,5444,5443,5442,5440,5439,5438,5437,5435,5408,5407,5406,5405,5397,5396,5395,5390,5389,5385,5377,5376,5374,5367,5348,5341,5337,5334,5333,5332,5327,5326,5288,5277,5276,5256,5254,5251,5248,5203,5202,5201,5200,5199,5194,5193,5192,5191,5189,5188,5187,5185,5183,5132,5125,5123,5117,5109,5105,5098,5095,5094,5093,5075,5073,5042,5018,5014,5007,5004,12448,12447,12444,12440,12439,12438,12436,12435,12434,12433,12427,12426,12425,12424,12408,12407,12406,12405,12404,12403,12398,12397,12395,12394,12393,12392,12391,12390,12370,12369,12366,12363,12362,12361,12360,12341,12334,12325,12323,12313,12287,12286,12285,12284,12283,12271,12270,12269,12267,12266,12265,12262,12261,12260,12259,12248,12245,12244,12243,12240,12236,12219,12218,12217,12216,12204,12201,12200,12199,12197,12196,12195,12194,12187,12176,12155,12146,12145,12144,12141,12138,12133,12131,12129,12128,12124,12123,12121,12119,12118,12117,12113,12112,12111,12110,12109,12108,12107,12106,12100,12085,12082,12070,12069,12068,12060,12059,12058,12057,12052,12049,12048,12047,12045,12044,12038,12021,8363,12811,10752,7703,5005,6612,6091,6089,12588,10747,11240,5059,6059,6549,9856,6942,10057,13332,7921,5267,5765,9848,5266,5667,7197,7156,8832,9020,9299,6805,9166,9508,8030,9979,10085,9971,9947,9946,8642,8599,8598,8597,8572,8569,8568,8548,8525,8516,8524,8540,8544,8689,8602,8595,8574,9980,9978,8400,7440,7290,8422,8409,8408,8406,8404,8402,8401,8399,8396,8395,8394,8392,8375,8373,8365,8364,8156,7878,7839,7837,7835,7832,7831,7830,7829,7828,7826,7825,7824,7822,7821,7770,7726,7724,7723,7700,7293,8555,6048,12979,13271,9563,9564,9035,5383,6617,6948,8035,8065,11173,7899,8374,12230,10044,9607,8115,9081,11286,12727,12728,12729,12730,12731,12732,13224,12733,12734,7118,8613,12450,8032,12984,10883,10199,10198,10454,11459,9007,10924,10843,13157,8691,8038,7823,6407,6406,13047,13169,11714,11220,11219,11218,11217,11216,11215,12462,7295,12980,13022,13041,6486,10328,9055,12399,12401,12402,12400,12494,12497,12493,12491,12553,12551,12552,6781,7286,9747,12692,12689,12688,12686,12743,12136,12464,9864,11675,5782,11827,9621,12186,8386,9969,12234,13021,12803,12919,13040,11816,11609,11436,10277,12634,13156,11312,5375,11140,13150,10459,10735,13024,12050,11397,11208,9429,8467,8466,8464,12978,12132,13152,12461,12428,12442,12549,5483,5484,13268,11534,9212,6657,13541,13540,13539,13520,13512,13500,13468,13467,13466,13447,13445,13443,13439,13432,13426,13424,13419,13418,13415,13412,13411,13410,13409,13408,13397,13396,13395,13376,13375,13374,13373,13372,13343,13342,13341,13340,13339,13338,13337,13336,13335,11801,11803,11805,11806,11807,11808,11810,11811,11813,12075,13516,12675,12674,12673,12672,12671,12670,12669,12668,12667,12666,12665,12664,12663,11502,11501,11500,11458,11457,11456,11455,11454,11109,8469,8453,11150,8451,13275,12272,12258,12257,12573,12572,12318,11380,11379,11378,11377,12071,8520,6446,11665,11148,10980,8468,8130,8129,8128,8127,9266,12249,11321,11225,9798,9434,9433,9432,9431,12073,10388,10275,11652,13515,11592,12550,13497,11802,13559,13272,12137,12139,12140,11127,13431,8641,11332,11241,11976,11743,11739,11705,11523,11200,10564,12061,13446,13613,13612,13596,13615,13614,13594,13593,13617,8617,10026,10025,12126,13595,13629,13623,13622,13398,11578,13377,8836,8835,8833,13107,11145,11850,11849,11614,5701,5690,11853,11845,5702,11615,5707,13214,12765,12762,11847,11846,13444,11602,12736,12105,7701,11511,11554,12053,12460,13511,12459,12458,13296,13448,13440,8834,13494,9435,9644,7287,9970,9912,6562,5517,5402,5401,5400,5399,13597,9953,9954,13702,13701,13700,13690,13663,13662,13624,13619,13610,13609,13605,13604,13603,13602,13601,13600,13599,13592,13590,13586,13585,13584,13580,13579,13578,13576,13575,13574,13573,13570,13569,13568,13567,13566,13565,13564,13547,13519,13517,8016,8015,8014,6152,8638,13628,13627,13626,12756,13126,13093,13118,12385,13587,13588,13589,12926,12923,12922,12920,13097,13095,13096,13094,13130,13129,13127,13128,11671,13495,10293,13469,13470,13471,13085,12134,11530,8554,13811,13809,13808,13807,12264,9561,9560,9559,9558,6655,6138,10736,13496,6405,11696,11690,11684,11685,11686,11687,11688,11689,11691,11692,11693,11694,12125,13475,13499,7161,11863,13290,13529,13528,13527,11791,11106,11105,11104,10462,12437,12263,11287,11117,10490,10324,10323,10321,10322,10325,11882,13709,13785,9911,11448,11349,5763,5775,11960,13563,13562,13561,5520,5164,11395,10417,10039,11879,12268,13043,13667,13598,13425,11804,13810,11107,11819,5739,5544,8523,10813,13577,12135,9977,7750,9849,13799,10297,10296,10295,10294,5091,10040,8391,13661,13778,10041,5384,10060,9549,12469,13526,13525,13524,6610,13784,13394,12540,10880,9571,12539,9273,11319,9904,12191,12192,12193,13227,13301,13300,13299,13297,11290,11212,11114,9507,9506,9505,10750,5403,13298,6892,7949,7390,5643,14470,14469,14468,10032,9976,11262,11963,12630,11553,13671,13669,13668,13664,13616,13039,13037,13036,13035,9955,9951,6450,11958,11957,11956,11955,11953,11951,5678,11954,11247,11341,14467,13034,11364,10982,10416,8678,8562,6699,12017,9581,8566,8988,14574,13591,14593,13618,12103,9234,9238,11403,11269,9504,7880,6656,6443,6442,12092,12091,12089,10078,10077,10076,10052,10051,9584,7385,7384,6595,13665,12389,12388,12387,12386,12371,12368,12367,12365,13158,13773,13768,14359,14348,14347,14346,14340,14338,14337,14335,14334,14333,14327,14326,14325,14324,14323,14322,14321,14320,14314,14313,14312,14311,14310,14309,14308,14307,14306,14305,14295,14294,14293,14292,14291,14290,14289,14288,14287,14286,14285,14284,14088,14087,14086,14076,14075,14074,13926,13924,13923,13922,13921,13920,13919,13913,13912,13911,13905,13904,13903,13878,13872,13871,13870,13869,13868,13867,13865,13864,13863,13853,13852,13851,13850,13849,13848,13847,13846,13845,13843,13842,13841,13840,13839,13838,13837,13836,13835,13834,13830,13829,13828,13827,13826,13825,13824,13823,13822,13821,13820,13819,13818,13817,13816,13815,13814,13813,13812,13798,13797,13786,14646,14643,14641,14635,14634,14633,14616,14601,14600,14599,14592,14591,14590,14589,14583,14582,14581,14580,14579,14578,14577,14576,14573,14572,14571,14570,14569,14568,14567,14566,14565,14564,14563,14562,14561,14560,14559,14558,14557,14556,14555,14554,14553,14552,14551,14550,14546,14545,14544,14543,14542,14539,14538,14537,14536,14534,14533,14532,14531,14530,14527,14526,14525,14524,14523,14522,14521,14520,14518,14513,14512,14511,14510,14509,14508,14507,14506,14505,14504,14503,14501,14500,14499,14498,14497,14496,14495,14494,14487,14486,14485,14484,14483,14482,14481,14480,14479,14478,14477,14476,14475,14474,14473,14472,14471,14462,14449,14448,14447,14441,14440,14439,14433,14432,14431,14418,14417,14416,14409,14408,14407,14371,14369,14368,14367,14366,14365,14364,14363,14362,14361,14360,10987,13498,13800,11797,11796,12760,12759,12758,12757,12807,12806,12805,12804,13125,13122,13121,13119,13092,13086,13088,13089,13243,13242,13241,13240,14690,14689,14688,14682,14681,14679,14678,14677,14675,14693,13858,10031,13294,13293,13292,13291,14698,14697,14673,5167,5166,5165,14742,14741,14740,14739,14738,14737,14736,14728,14726,14725,14724,14723,14722,14721,14720,14718,14717,13572,14748,14749,14519,5373,14771,14765,14764,14762,14761,14760,14759,13887,14349,14787,10276,14644,7725,14676,14819,14818,14817,14816,14815,14814,14807,14806,14805,14804,14799,14798,14797,14796,14795,14794,14823,14822,14820,11740,5108,6557,10915,10872,10557,10363,5642,9151,9542,9543,9620,9625,9627,9628,9629,11695,14831,14830,14829,14843,14842,14841,14835,14834,14833,14832,14855,14854,14853,14848,14847,14846,14845,14844,9022,9024,9023,9446,10128,10249,10250,10282,10856,11009,11343,11549,5247,7894,7896,6147,6757,7510,9109,9110,11177,11981,14353,14867,14866,14865,14859,14858,14857,14856,14887,14886,14879,14878,14877,14876,11533,11527,14894,5639,5730,5630,11988,14895,14727,14907,14906,14905,14899,14898,14896,14897,14891,14889,14888,5629,13480,10415,14908,13666,13670,12180,12179,12178,11254,11253,11252,14926,14925,14924,14923,14922,14921,14920,14914,14913,14912,14911,14793,14813,14931,14930,14929,14928,14927,14630,14719,13648,13654,11460,10984,13649,13653,13652,13651,11939,9006,9005,13655,12541,10354,14935,14934,14932,14943,14942,14941,14954,14953,14973,14972,14970,14763,14985,14983,14984,14974,14975,14976,14977,5677,9883,15003,15002,15001,15000,14997,14996,14995,14994,14993,14992,14991,8992,13772,13770,14933,15042,15041,15040,15039,15038,15037,15036,15028,15027,11331,11172,9667,6034,5252,14350,10885,10314,10906,10561,6597,14351,10396,7718,7717,13650,8625,8624,8623,8622,11433,11432,11431,11430,13660,13659,13658,13657,13892,5253,5255,9270,9570,9646,10568,11320,11711,5713,9003,9004,13771,9008,9009,9902,10882,11529,10035,15051,15050,15049,15017,15016,15015,15014,5269,5325,10852,12790,12791,12792,12793,12794,12795,12796,12797,12798,12799,12800,12801,14885,14821,15060,15068,15067,15066,15065,15081,15080,15079,15073,15072,15071,15070,11809,15029,15099,15098,15097,15091,15092,15090,15089,6052,14434,14411,14315,14069,14328,10379,15123,15124,15125,15126,15131,15132,15133,15134,15135,15136,15137,12981,6783,6782,15113,15114,15115,15069,14680,15143,15145,15144,15141,15140,7705,5176,5177,5178,5250,14802,14801,14800,14971,15154,15153,15152,15147,9259,9260,9261,9100,8452,8454,13501,7365,11812,5674,7709,8561,14535,11673,15094,5305,5306,5307,5308,5086,15189,15188,15187,15181,15180,15179,15178,15173,15174,15175,15201,15200,15199,15194,15193,15192,15191,15190,15213,15212,15211,15210,15209,15208,15207,14694,15222,15221,15220,15215,15230,15229,15228,9269,15247,15245,15246,15248,15249,15250,15244,13611,13186,13185,13184,12484,12483,12482,12481,12480,12479,12478,12477,11560,11542,11538,11358,11342,11539,11233,10000,9552,8571,8117,14632,15142,15167,15177,15270,15269,15268,15262,15261,15260,15259,15256,15251,15280,15279,15278,15273,10762,11753,11752,11751,11750,11749,11748,11747,11746,15281,15285,15286,15289,15288,15323,15322,15321,15320,15319,15318,15317,15316,15315,15314,15326,15331,15332,15333,15334,15335,15336,15337,15338,15339,15340,10877,10055,10056,10229,10857,15347,15348,15352,15350,15351,15353,15354,15355,15356,5404,12359,12364,12472,15359,15349,14628,11429,14354,14880,14836,14607,14608,14609,13532,14631,14406,14405,14404,14403,14430,14428,14427,15376,15375,15382,15384,11829,11503,11214,11250,11260,11375,12700,10326,12130,11492,13064,11788,13656,11720,12722,13189,13914,13906,5304,12090,6512,13413,9076,9096,9106,9116,15417,15415,15414,15413,15412,15411,15410,15409,15408,15157,15430,15429,15428,15427,15433,15434,15403,15443,15442,15441,15444,15458,15457,15455,15454,15453,15452,15450,15449,15448,15447,15446,15459,15460,15461,15462,15463,15435,5516,15374,15373,15372,15371,15370,15369,15368,15367,15366,15365,15468,15469,15470,15471,15473,15474,15475,15476,15477,14824,14584,14731,9842,15492,15490,15488,15487,15486,15485,15484,15483,15503,15502,15500,15499,15498,15493,14860,5558,11101,10352,5611,15506,5562,5561,5560,15489,11563,11099,10959,9418,8482,8043,8042,8041,8040,15512,15517,15518,15519,15520,15521,15522,15523,15526,15525,15524,14951,14950,14949,14944,14714,14713,14890,14750,14700,13895,13894,13893,13891,13890,13889,13877,13876,13873,13874,13875,13514,13430,13429,13428,14715,14716,12072,7196,6449,6448,14936,14683,14610,14594,13068,13067,13066,13065,13193,13192,13190,13196,12726,12725,12724,12723,12704,12703,12701,12707,12432,12431,12430,12429,12446,12445,12443,12449,9199,9200,9201,9202,15545,15547,15546,15548,15549,15550,15551,15552,15553,15554,15555,10860,15558,14699,13783,14735,14733,14732,14812,14811,14810,14809,15559,13239,9025,7388,9034,13081,10042,15560,8407,5676,15562,15563,15561,15564,15565,15566,14808,14900,14691,13844,15491,15416,15583,15582,15581,15580,15579,15578,15577,15576,15575,15574,15527,15584,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15602,15603,15626,15625,15624,15501,15642,15641,15639,15638,15637,15636,15635,15634,15633,15628,14663,14662,14661,14656,15645,15646,15647,15652,15653,15654,15655,15656,15657,15658,15640,15662,15669,15667,15668,15670,15671,15672,15673,15676,15675,15679,15678,15677,15621,15586,15630,6038,6037,6036,6035,6550,6552,6551,6553,6872,6871,6870,6868,7946,7944,7943,8068,8069,8067,8066,8448,8447,15681,15684,9011,9014,9013,15686,15687,9012,15688,9165,9164,9163,9162,9512,9511,9510,9509,15703,15702,15701,15700,15699,15698,15697,15696,15694,10742,10741,10740,10739,15695,15711,15710,15709,15717,15718,15719,15680,6103,11799,13888,15383,15445,14734,15714,15627,15287,15732,15744,15743,15742,15740,15739,15737,15738,15736,15735,15733,15734,15741,6608,15085,15084,15083,15122,15120,15119,15130,15128,15127,15571,15706,15649,5604,15770,15769,15768,15767,15766,15765,15764,15763,15762,15761,15756,14615,15775,15776,15790,15789,15788,15787,15786,15785,15784,15783,15782,10948,14339,14352,8837,14904,14903,14902,14901,14852,14851,14850,14849,14864,14863,14862,14861,15034,15033,15032,14948,14947,14946,14945,14982,14981,14980,14979,13898,15108,15074,15031,14788,15683,15807,15806,15805,15804,15803,15802,15801,15800,15799,15798,15793,15808,15809,15810,15811,7387,9156,13518,15812,15813,15814,15815,15816,15035,15096,15758,15817,15818,15821,15822,15823,15824,15825,15841,15840,15839,15838,15837,15836,15835,15834,15833,15832,15831,12410,15843,15846,15847,15849,15850,15848,15844,15856,15858,15859,15860,15861,15862,15863,15864,15851,15842,15855,15854,15853,15865,15866,15206,15204,15203,15870,15871,15872,15874,15873,11396,11376,6609,15852,14670,11025,6900,11144,13866,12185,11864,15301,11841,11191,12232,15891,15892,15894,15895,15896,15897,15898,15899,15900,15901,15902,15903,15905,15904,15906,15303,15828,15914,15893,15913,15912,15908,15907,9820,9819,9818,15922,15921,15920,11184,11664,12282,15456,8423,8310,8139,7748,14304,14303,14302,14300,14301,10086,10038,10037,6959,7769,11199,10923,9243,9242,9241,9240,9239,15923,15928,15929,15930,15886,15931,15867,15909,13774,14370,15541,15620,15585,15629,15093,15934,15933,15917,15588,9975,14642,11842,14978,15263,15168,13334,15604,15465,15937,12016,11843,11844,12015,9591,15674,9699,11707,10886,10800,11159,11556,12114,15258,15257,12120,15713,15095,15121,15129,15205,15619,15712,12538,12537,12536,12548,12543,12542,15949,15948,15951,15950,12633,11974,15967,15965,15964,15963,15985,15984,15983,15982,15981,16015,16014,16013,16011,16012,16006,16005,16004,16003,16002,16001,16045,16044,16043,16042,16041,16060,16059,16058,16057,16056,16000,15999,15998,15997,15996,15991,15990,15989,15988,15987,15986,16061,15544,15573,15198,15197,15196,15195,15227,15226,15225,15224,15243,15242,15241,15240,15330,15329,15328,15327,15255,15254,15253,15252,16063,16064,16065,16067,14636,14754,15044,15182,15309,15478,15223,15118,15540,16068,16069,16070,15932,16088,16087,16086,16085,16084,16098,15759,14336,6600,12014,16102,16103,15757,11728,11968,11967,5522,8541,16104,14415,14414,14413,14412,14587,14585,14332,14331,14330,14329,14358,14357,14356,14355,14828,14827,14826,14825,14639,14637,13862,13861,13860,13859,14345,14343,14342,14319,14318,14317,14316,14660,14659,14658,14657,14792,14791,14790,14789,14758,14757,14756,14884,14883,14882,14881,14597,14687,14686,14685,14684,14666,14769,14768,14767,14606,14605,14604,14073,14072,14071,14070,13910,13909,13908,13907,13479,13478,13477,13476,13782,13781,13780,13779,14438,14437,14436,14435,13536,13535,13534,13533,13918,13917,13916,13915,12781,12784,12783,12787,13420,13417,13416,13414,14598,14596,14595,14586,14588,14611,14638,14640,15993,16008,15360,14990,14989,14988,14987,15277,15276,15275,15274,14919,14918,14917,14916,15048,15047,15045,15151,15150,15149,15148,15219,15218,15217,15216,15664,15663,14940,14939,14938,14937,15112,15111,15110,15109,14840,14839,14838,14837,15172,15171,15170,15169,15078,15077,15076,15075,15407,15406,15405,15404,15516,15515,15514,15513,15482,15481,15480,15479,15313,15311,15346,15345,15344,15267,15266,15265,15264,15497,15496,15495,15494,15186,15185,15184,15183,15046,15542,6451,15692,15691,15690,15827,15916,12127,5368,16110,16112,16113,16115,16114,16119,16125,16121,16120,16124,16123,16127,8362,7827,13902,13901,13900,13899,14282,14281,14280,14279,15777,12202,16137,15760,15830,16139,16138,16155,16154,16153,16152,16151,16150,16149,16148,16147,16146,16145,16144,16143,16141,16142,16135,16131,16157,16169,16166,16165,16163,16160,16159,16158,16171,16170,16168,16161,16173,11869,11361,5538,11245,8339,16201,16197,16195,16192,16191,16190,16189,16186,16182,16180,16177,15665,15715,16193,16203,16202,16200,16174,16176,16188,16178,16185,12767,16209,16207,16230,16229,16228,16227,16226,15632,15623,15666,15716,15693,12457,16212,16205,16140,15829,16238,15570,16204,16162,16253,16254,16252,16251,16246,16179,16187,16266,16265,12632,16268,16269,16272,16273,16274,16275,16276,16277,16278,16279,16270,16267,16293,16294,16295,11125,12229,16341,16317,11876,11878,12737,12738,14402,16351,5272,8560,16194,16271,15572,15707,15650,15868,15910,15543,8515,16357,16358,6943,15432,15431,15426,15425,15364,15363,15362,15361,6033,6032,14617,14502,11531,8449,11512,11717,10266,8450,14614,11528,15342,15343,6867,16373,16372,3000,16370,16362,16371,16367,16369,16368,16374,15938,15940,15943,15944,15945,15946,15947,15955,15959,15958,15960,15961,15962,15971,15973,15976,15977,15978,15979,15980,16046,16048,16051,16052,16053,16054,16055,16039,16040,16031,16033,16036,16038,16037,16074,16076,16079,16080,16081,16083,16082,16090,16092,16095,16096,16097,16216,16218,16221,16222,16223,16224,16225,16233,16235,16239,16240,16241,16247,16248,16249,16250,16255,16256,16257,16258,16259,16260,16261,16262,16264,16263,16290,16289,16283,16288,16292,16291,16285,15919,15957,15975,16035,16094,15176,16126,12104,14283,14952,11087,11193,11345,12051,11886,15780,15779,15778,15685,15651,16392,16391,16389,16390,16381,16388,16387,16386,16384,11972,16364,16393,16395,16396,16398,16400,16401,16409,16402,16403,16411,16404,16405,16407,16408,15708,16424,16414,16415,16416,16417,16419,16420,16421,16422,16423,16425,16418,15918,15956,15974,16034,15796,15795,15794,12635,16383,16441,16440,16439,16436,16435,16437,16438,16429,16434,16430,16431,16432,16433,16454,16453,16452,16449,16448,16450,16451,16442,16447,16446,16445,16444,16443,16356,16353,16352,15682,16456,16458,16459,16460,16461,16462,16463,16464,16465,16467,16468,16469,14755,6040,6866,16478,16491,16490,16489,16486,16485,16475,16474,16472,16471,16470,16487,16488,16479,16484,16483,16482,16481,16480,16473,15569,15689,15826,11649,16503,16502,16499,16498,16493,16504,16505,16500,16501,16492,16497,16507,16508,15009,16509,16510,16511,16512,16513,9749,12721,16525,16524,16523,16522,16521,16520,16519,16518,16517,16516,16515,16514,16540,16539,16538,16535,16534,16536,16537,16528,16533,16529,16530,16531,16532,16477,16220,16237,16476,6511,16574,16573,16572,16571,16570,16569,16568,16587,16585,16584,16583,16579,16576,16575,16582,16581,16580,7995,16614,16613,16612,16609,16608,16607,16610,16611,16601,16606,16605,16604,16603,16602,16628,16627,16626,16623,16622,16621,16624,16625,16615,16620,16619,16618,16617,16616,16050,15797,15869,15911,15992,16078,15942,16093,8567,16631,16630,16632,16633,15568,16634,16635,16636,16637,16136,15954,16091,15972,16032,16217,16167,8549,5951,12011,9595,15402,16466,16586,16526,8148,16653,16650,16649,16646,16644,14915,16642,16643,16645,16651,16667,16666,16665,16661,16660,16682,16681,16680,16677,16676,16675,16663,16664,16654,16659,16658,16657,16656,16655,16678,16679,16669,16674,16673,16672,16671,16670,16219,16236,16183,16695,16694,16693,16692,16691,16690,16689,16684,16683,16709,16708,16707,16704,16703,16702,16705,16706,16696,16701,16700,16699,16698,16697,16722,16721,16717,16716,16719,16720,16710,16715,16737,16736,16735,16731,16730,16728,16727,16726,16725,16733,16734,16724,16729,16749,16747,16746,16744,16740,10738,16748,16741,16738,16739,16718,16732,14803,14344,9530,10089,16175,16365,16494,15567,16750,16762,16761,16755,16754,15202,5715,10869,13225,14645,16752,16753,16756,16763,16116,16751,16767,16780,16779,16778,16775,16774,16164,16181,16366,16385,16776,16777,16768,16773,16772,16771,16770,16769,16793,16792,16791,16788,16787,16789,16790,16781,16786,16785,16784,16783,16782,16794,16795,16796,16797,16798,16799,16800,16457,16399,15705,16801,16231,16030,16029,16028,16027,16026,16025,16024,16023,16022,16021,16020,16016,16017,16018,16019,16397,16506,16156,16410,16686,16712,7716,7715,16814,16813,16812,16809,16808,16807,16806,16805,16804,16803,16810,16811,16802,16009,15941,16049,15994,16577,9601,16828,16827,16826,16823,16822,16821,16824,16825,16815,16820,16819,16818,16817,16816,16841,16840,16839,16838,16837,16836,16835,16834,16833,16832,16830,16829,16375,16662,16394,16122,5051,12205,10888,7527,7526,9599,10881,6936,10884,10887,7117,16758,16062,15059,15058,15057,15056,15055,15054,15053,15052,15013,15012,15011,15010,6058,16412,16865,16864,16863,16860,16859,16858,16861,16862,16852,16857,16856,16855,16854,16853,16648,16743,16879,16878,16877,16874,16873,16872,16875,16876,16866,16871,16870,16869,16868,16867,16893,16892,16891,16888,16887,16886,6440,6437,16889,16890,16880,16885,16884,16883,16882,16881,16906,16905,16904,16901,16900,6886,16902,16903,16894,16899,16898,16897,16896,16895,16920,16919,16918,16915,16914,16913,16916,16917,16907,16912,16911,16910,16909,16908,16934,16933,16932,16929,16928,16927,16930,16931,16921,16926,16925,16924,16923,16922,16948,16947,16946,16943,16942,16941,16944,16945,16935,16940,16939,16938,16937,16936,9619,7421,7357,5249,16962,16961,16960,16957,16956,16955,16958,16959,16949,16954,16953,16952,16951,16950,16831,15966,9917,15952,16077,16966,16967,16968,7358,16969,16983,16982,16981,16978,16977,16976,16979,16980,16970,16975,16974,16973,16972,16971,16997,16996,16995,16992,16991,16990,16988,16987,16986,16985,16993,16994,16984,16989,16638,17011,17010,17009,17006,17005,17004,17007,17008,16998,17003,17002,17001,17000,16999,17025,17023,17020,17019,17018,17021,17022,17012,17017,17016,17015,17014,17013,16764,15781,15440,15439,15438,15437,17026,17024,14341,17039,17038,17037,17034,17033,17035,17036,17027,17032,17031,17030,17029,17028,17053,17052,17051,17048,17047,17046,17049,17050,17040,17045,17044,17043,17042,17041,17067,17066,17065,17062,17061,17060,17063,17064,17054,17059,17058,17057,17056,17055,17081,17080,17079,17076,17075,17074,17077,17078,17068,17073,17072,17071,17070,17069,17095,17094,17093,17090,17089,17088,17091,17092,17082,17087,17086,17085,17084,17083,17112,17111,17110,17107,17106,17105,17108,17109,17099,17104,17103,17102,17101,17100,12177,14998,17128,17127,17126,17123,17122,17121,17124,17125,17115,17120,17119,17118,17117,17116,13216,15030,8573,6776,9263,9901,9900,9945,13560,13513,13407,13406,13405,14613,13775,13769,14770,14612,14773,14772,16406,14766,17129,17130,16842,17131,17132,14426,14429,15312,15451,16234,16184,16382,16363,15845,15310,17133,9769,6083,17148,17147,17146,17143,17142,17141,17144,17145,17135,17140,17139,17138,17137,17136,15341,14752,5704,14692,6806,14602,14603,10058,9704,14629,16687,16713,16759,16647,17159,17160,6141,16111,15504,17175,17174,17173,17170,17169,17168,17171,17172,17162,17167,17166,17165,17164,17163,17176,17177,17178,17179,17180,17181,17182,17186,16280,16172,16129,15915,14278,15239,15436,15968,15088,16117,14753,15704,17194,17195,17188,17196,13449,17189,17197,17198,17190,17199,17191,17200,17201,17193,17192,17202,17203,17207,17206,17204,14672,15556,17223,17222,17221,17218,17217,17216,17219,17220,17210,17215,17214,17213,17212,17211,17224,17228,17243,17242,17241,17238,17237,17236,17134,17227,17229,17239,17240,17230,17235,17234,17233,17232,17231,17244,17245,17246,17247,17248,17249,17250,17251,13313,17226,15753,17253,17252,17254,17255,17259,17258,17257,17256,8553,16075,15648,15939,16047,16010,16199,16757,9789,15082,15557,11175,10431,9586,6064,6065,6066,17318,17317,17316,17315,17314,17313,17312,17311,17310,17309,17308,17307,17305,17304,17303,17302,17301,17300,17299,17298,16128,17297,17296,17295,17293,17292,17290,17260,17289,17285,17284,17283,17282,17281,17280,17279,17278,17277,17276,17275,17274,17271,15927,15926,15925,15924,16211,16210,16206,16243,16242,17261,17319,17263,17264,17265,17266,17267,17268,17269,17270,17272,17273,17294,17288,17287,17320,11877,17336,17335,17334,17333,15995,16284,16742,17321,17322,17324,17325,17326,17328,17329,17330,17331,17332,17327,17323,17262,16281,17363,17362,17361,17360,17359,17358,17357,17356,17355,17354,17351,17350,17352,17353,13583,13582,13581,17349,17366,17365,17364,17291,8687,17382,17383,17384,17385,17386,17400,17399,17398,17397,17396,17387,17395,17401,17393,17392,17391,17390,17389,17394,17388,17205,17404,17403,17405,17406,16714,16760,16688,17407,17408,17409,17410,17411,17412,17413,17414,17415,17429,17428,17427,17424,17423,17422,17425,17426,17416,17421,17420,17419,17418,17417,17430,17444,17443,17442,17439,17438,17437,17440,17441,17431,17436,17435,17434,17433,17432,17459,17458,17457,17454,17453,17452,17455,17456,17446,17451,17450,17449,17448,17447,17466,17467,17465,17464,17463,17462,17468,17461,17460,17495,17499,17500,17501,17483,17496,17502,17503,17504,17505,17498,17506,17497,17494,17469,17493,17470,17492,17491,17471,17489,17472,17488,17473,17474,17475,17476,17487,17478,17486,17485,17484,17507,17479,17508,17480,17481,17511,17510,17482,17513,17512,17477,17509,6266,17514,16196,16208,16245,16287,16007,16496,16652,16745,17521,17522,17523,17524,17525,17526,17527,17530,8987,17544,17543,17542,17539,17538,17537,17540,17541,17531,17536,17535,17534,17533,17532,16244,16286,16337,16495,16578,15622,15631,15587,17545,17529,17528,6961,17546,17490,17547,17548,17550,17551,17552,17553,17554,17555,17556,17558,17557,16711,16685,11163,11251,17306,-1', ',') select count(0) from [RB_Amazon_Product_Base] (nolock) vtb LEFT JOIN RB_StockClearDetailed scd (nolock) ON(vtb.OrderSourceSKUID=scd.ListId AND vtb.CustomerID=scd.CustomerID AND (clearType=1 OR clearType=3))
LEFT JOIN RB_StockClearStrategy scs (nolock) ON(scd.scsID=scs.ID AND scd.CustomerID=scs.CustomerID)
LEFT JOIN (SELECT sum(GoodNum) AS Inventory,WareHouseID,SKU,CustomerID FROM RB_WareHouse_Product (nolock) GROUP BY WareHouseID,SKU,CustomerID) AS tbWHN ON(vtb.WID=tbWHN.WareHouseID AND vtb.SKU=tbWHN.SKU AND vtb.CustomerID=tbWHN.CustomerID)
LEFT JOIN RB_WareHouse w (nolock) ON w.CustomerID=vtb.CustomerID and w.ID=vtb.DefaultWarehouseID
LEFT JOIN RB_OrderSource o (nolock) on vtb.CustomerID=o.CustomerID and vtb.OrderSourceID = o.ID
Left join RB_Product_Admin pa(nolock) on vtb.CustomerID=pa.CustomerID and vtb.SKU = pa.SKU
left join RB_Product p (nolock) on p.CustomerID=vtb.CustomerID and vtb.SKU = p.SKU
left join RB_WareHouse wh(nolock) on wh.CustomerID=p.CustomerID and wh.ID=p.DefaultLocalWarehouse
left join RB_WareHouse swh(nolock) on swh.CustomerID=vtb.CustomerID and swh.ID=vtb.TheWareHouseID
left join RB_Amazon_NotToFbaReason ntf (nolock) on vtb.CustomerID=ntf.CustomerID and vtb.NotToFbaReasonId=ntf.ID INNER JOIN #tb_Amazon_OrderSourceIDs IDS on vtb.OrderSourceID=IDS.Id WHERE vtb.CustomerID=@CustomerID AND vtb.IsDelete=0 and msaleNum>=@msaleNum1 and isnull(IsOffShelf,0) in (1,4,5,2,0) and vtb.OrderSourceSKUID>0 And vtb.OnShelfMode in (SELECT CONVERT(INT, item) FROM Charsplitforin(@OnShelfMode, ',')) AND p.ClassID1=@CategoryID option(maxdop 8)
PARAMS:@CustomerID = 1 ,@UserID = 692 ,@Count1 = ,@Count2 = ,@msaleNum1 = 5 ,@OnShelfMode = 1,2 ,@CategoryID = 7105 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteScalar()
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtend.RB_Amazon_Product_BaseExtend.GetModelPagerList(RB_Amazon_Product_Base_PSParameters parameters, Int32& recordCount, String FolderID, Int32 CustomerID, Int32 AdminID, List`1 PermissionAdminIds, Int32 currentAdminId, String childWhere)
在 PandaBuy.ERP.Web.IrobotBox.Amazon.AmazonListingList.Page_Load(Object sender, EventArgs e)
在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
在 System.Web.UI.Control.OnLoad(EventArgs e)
在 System.Web.UI.Control.LoadRecursive()
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest()
在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.irobotbox_amazon_amazonlistinglist_aspx.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
重现步骤
示例：
declare @ids varchar(max)='46495781,46495779,46495658';
declare @res table(item varchar(400));
insert into @res
exec proc_string_split @ids,',' ;
select * from @res;
技术大群有发过。