use ItemMonster;


UPDATE itemmonster SET associationid = 1737 WHERE associationId = 1733;
UPDATE itemmonster SET associationid = 1853 WHERE associationId = 1132;
UPDATE itemmonster SET associationid = 2267 WHERE associationId = 870;
UPDATE itemmonster SET associationid = 2225 WHERE associationId = 2193;
UPDATE itemmonster SET associationid = 1993 WHERE associationId = 8;
UPDATE itemmonster SET associationid = 2437 WHERE associationId = 264;
UPDATE itemmonster SET associationid = 2393 WHERE associationId = 2139;
UPDATE itemmonster SET associationid = 2393 WHERE associationId = 2319;
UPDATE itemmonster SET associationid = 2287 WHERE associationId = 2253;
UPDATE itemmonster SET associationid = 25 WHERE associationId = 1839;
UPDATE itemmonster SET associationid = 840 WHERE associationId = 839;
UPDATE itemmonster SET associationid = 2269 WHERE associationId = 2235;
UPDATE itemmonster SET associationid = 2415 WHERE associationId = 2403;
UPDATE itemmonster SET associationid = 1478 WHERE associationId = 1473;
UPDATE itemmonster SET associationid = 2281 WHERE associationId = 2243;
UPDATE itemmonster SET associationid = 2109 WHERE associationId = 1463;
UPDATE itemmonster SET associationid = 2109 WHERE associationId = 2315;
UPDATE itemmonster SET associationid = 2643 WHERE associationId = 2567;
UPDATE itemmonster SET associationid = 1987 WHERE associationId = 1573;
UPDATE itemmonster SET associationid = 1419 WHERE associationId = 1418;
UPDATE itemmonster SET associationid = 2379 WHERE associationId = 2321;
UPDATE itemmonster SET associationid = 2385 WHERE associationId = 1967;
UPDATE itemmonster SET associationid = 2385 WHERE associationId = 2323;
UPDATE itemmonster SET associationid = 1673 WHERE associationId = 41;
UPDATE itemmonster SET associationid = 1673 WHERE associationId = 42;
UPDATE itemmonster SET associationid = 2295 WHERE associationId = 43;
UPDATE itemmonster SET associationid = 1671 WHERE associationId = 44;
UPDATE itemmonster SET associationid = 2391 WHERE associationId = 2325;
UPDATE itemmonster SET associationid = 2389 WHERE associationId = 2327;
UPDATE itemmonster SET associationid = 2383 WHERE associationId = 2329;
UPDATE itemmonster SET associationid = 2387 WHERE associationId = 2331;
UPDATE itemmonster SET associationid = 267 WHERE associationId = 2247;
UPDATE itemmonster SET associationid = 267 WHERE associationId = 2011;
UPDATE itemmonster SET associationid = 1565 WHERE associationId = 324;
UPDATE itemmonster SET associationid = 1565 WHERE associationId = 1564;
UPDATE itemmonster SET associationid = 2539 WHERE associationId = 2335;
UPDATE itemmonster SET associationid = 2539 WHERE associationId = 2425;
UPDATE itemmonster SET associationid = 2197 WHERE associationId = 2147;
UPDATE itemmonster SET associationid = 2705 WHERE associationId = 376;
UPDATE itemmonster SET associationid = 2631 WHERE associationId = 2555;
UPDATE itemmonster SET associationid = 2265 WHERE associationId = 1151;
UPDATE itemmonster SET associationid = 2097 WHERE associationId = 2043;
UPDATE itemmonster SET associationid = 1461 WHERE associationId = 1460;
UPDATE itemmonster SET associationid = 2527 WHERE associationId = 2203;
UPDATE itemmonster SET associationid = 2527 WHERE associationId = 2293;
UPDATE itemmonster SET associationid = 711 WHERE associationId = 393;
UPDATE itemmonster SET associationid = 1150 WHERE associationId = 1145;
UPDATE itemmonster SET associationid = 1296 WHERE associationId = 68;
UPDATE itemmonster SET associationid = 2181 WHERE associationId = 2153;
UPDATE itemmonster SET associationid = 1667 WHERE associationId = 76;
UPDATE itemmonster SET associationid = 740 WHERE associationId = 741;
UPDATE itemmonster SET associationid = 1471 WHERE associationId = 743;
UPDATE itemmonster SET associationid = 769 WHERE associationId = 744;
UPDATE itemmonster SET associationid = 709 WHERE associationId = 383;
UPDATE itemmonster SET associationid = 2261 WHERE associationId = 955;
UPDATE itemmonster SET associationid = 144 WHERE associationId = 1300;
UPDATE itemmonster SET associationid = 1675 WHERE associationId = 1159;
UPDATE itemmonster SET associationid = 1767 WHERE associationId = 1749;
UPDATE itemmonster SET associationid = 2639 WHERE associationId = 2563;
UPDATE itemmonster SET associationid = 1991 WHERE associationId = 1451;
UPDATE itemmonster SET associationid = 276 WHERE associationId = 102;
UPDATE itemmonster SET associationid = 2381 WHERE associationId = 2339;
UPDATE itemmonster SET associationid = 2541 WHERE associationId = 2341;
UPDATE itemmonster SET associationid = 2541 WHERE associationId = 2427;
UPDATE itemmonster SET associationid = 2209 WHERE associationId = 2137;
UPDATE itemmonster SET associationid = 2417 WHERE associationId = 2405;
UPDATE itemmonster SET associationid = 1251 WHERE associationId = 107;
UPDATE itemmonster SET associationid = 388 WHERE associationId = 372;
UPDATE itemmonster SET associationid = 1085 WHERE associationId = 1124;
UPDATE itemmonster SET associationid = 715 WHERE associationId = 1305;
UPDATE itemmonster SET associationid = 2645 WHERE associationId = 2569;
UPDATE itemmonster SET associationid = 2647 WHERE associationId = 2571;
UPDATE itemmonster SET associationid = 2535 WHERE associationId = 2347;
UPDATE itemmonster SET associationid = 2535 WHERE associationId = 2421;
UPDATE itemmonster SET associationid = 699 WHERE associationId = 1560;
UPDATE itemmonster SET associationid = 2649 WHERE associationId = 1799;
UPDATE itemmonster SET associationid = 2649 WHERE associationId = 2573;
UPDATE itemmonster SET associationid = 2395 WHERE associationId = 2349;
UPDATE itemmonster SET associationid = 2651 WHERE associationId = 2575;
UPDATE itemmonster SET associationid = 2627 WHERE associationId = 2551;
UPDATE itemmonster SET associationid = 2543 WHERE associationId = 2353;
UPDATE itemmonster SET associationid = 2543 WHERE associationId = 2429;
UPDATE itemmonster SET associationid = 2419 WHERE associationId = 2407;
UPDATE itemmonster SET associationid = 15 WHERE associationId = 281;
UPDATE itemmonster SET associationid = 917 WHERE associationId = 2743;
UPDATE itemmonster SET associationid = 2375 WHERE associationId = 2355;
UPDATE itemmonster SET associationid = 311 WHERE associationId = 745;
UPDATE itemmonster SET associationid = 2263 WHERE associationId = 985;
UPDATE itemmonster SET associationid = 2447 WHERE associationId = 1364;
UPDATE itemmonster SET associationid = 2653 WHERE associationId = 2577;
UPDATE itemmonster SET associationid = 1989 WHERE associationId = 285;
UPDATE itemmonster SET associationid = 2545 WHERE associationId = 2357;
UPDATE itemmonster SET associationid = 2545 WHERE associationId = 2431;
UPDATE itemmonster SET associationid = 2547 WHERE associationId = 2359;
UPDATE itemmonster SET associationid = 2547 WHERE associationId = 2433;
UPDATE itemmonster SET associationid = 2549 WHERE associationId = 2435;
UPDATE itemmonster SET associationid = 721 WHERE associationId = 729;
UPDATE itemmonster SET associationid = 721 WHERE associationId = 730;
UPDATE itemmonster SET associationid = 721 WHERE associationId = 963;
UPDATE itemmonster SET associationid = 1941 WHERE associationId = 1689;
UPDATE itemmonster SET associationid = 1362 WHERE associationId = 1361;
UPDATE itemmonster SET associationid = 1923 WHERE associationId = 1433;
UPDATE itemmonster SET associationid = 163 WHERE associationId = 164;
UPDATE itemmonster SET associationid = 1215 WHERE associationId = 167;
UPDATE itemmonster SET associationid = 215 WHERE associationId = 804;
UPDATE itemmonster SET associationid = 215 WHERE associationId = 802;
UPDATE itemmonster SET associationid = 215 WHERE associationId = 803;
UPDATE itemmonster SET associationid = 215 WHERE associationId = 773;
UPDATE itemmonster SET associationid = 168 WHERE associationId = 1185;
UPDATE itemmonster SET associationid = 2411 WHERE associationId = 2399;
UPDATE itemmonster SET associationid = 2635 WHERE associationId = 1691;
UPDATE itemmonster SET associationid = 2635 WHERE associationId = 2559;
UPDATE itemmonster SET associationid = 1863 WHERE associationId = 1693;
UPDATE itemmonster SET associationid = 176 WHERE associationId = 177;
UPDATE itemmonster SET associationid = 2273 WHERE associationId = 2233;
UPDATE itemmonster SET associationid = 895 WHERE associationId = 929;
UPDATE itemmonster SET associationid = 1505 WHERE associationId = 1439;
UPDATE itemmonster SET associationid = 2213 WHERE associationId = 119;
UPDATE itemmonster SET associationid = 1735 WHERE associationId = 1723;
UPDATE itemmonster SET associationid = 2167 WHERE associationId = 1877;
UPDATE itemmonster SET associationid = 2531 WHERE associationId = 2113;
UPDATE itemmonster SET associationid = 1496 WHERE associationId = 1503;
UPDATE itemmonster SET associationid = 1959 WHERE associationId = 1983;
UPDATE itemmonster SET associationid = 1695 WHERE associationId = 1313;
UPDATE itemmonster SET associationid = 1913 WHERE associationId = 1367;
UPDATE itemmonster SET associationid = 2637 WHERE associationId = 2561;
UPDATE itemmonster SET associationid = 1857 WHERE associationId = 1709;
UPDATE itemmonster SET associationid = 2633 WHERE associationId = 2557;
UPDATE itemmonster SET associationid = 220 WHERE associationId = 219;
UPDATE itemmonster SET associationid = 1943 WHERE associationId = 1018;
UPDATE itemmonster SET associationid = 1943 WHERE associationId = 1861;
UPDATE itemmonster SET associationid = 2641 WHERE associationId = 2565;
UPDATE itemmonster SET associationid = 2377 WHERE associationId = 2369;
UPDATE itemmonster SET associationid = 1851 WHERE associationId = 1014;
UPDATE itemmonster SET associationid = 1626 WHERE associationId = 1627;
UPDATE itemmonster SET associationid = 236 WHERE associationId = 750;
UPDATE itemmonster SET associationid = 2629 WHERE associationId = 1697;
UPDATE itemmonster SET associationid = 2629 WHERE associationId = 1795;
UPDATE itemmonster SET associationid = 2629 WHERE associationId = 2553;
UPDATE itemmonster SET associationid = 2409 WHERE associationId = 2397;
UPDATE itemmonster SET associationid = 1977 WHERE associationId = 301;
UPDATE itemmonster SET associationid = 2219 WHERE associationId = 2123;
UPDATE itemmonster SET associationid = 1188 WHERE associationId = 1212;
UPDATE itemmonster SET associationid = 2297 WHERE associationId = 250;
UPDATE itemmonster SET associationid = 1262 WHERE associationId = 1261;
UPDATE itemmonster SET associationid = 311 WHERE associationId = 732;
UPDATE itemmonster SET associationid = 311 WHERE associationId = 734;
UPDATE itemmonster SET associationid = 311 WHERE associationId = 733;
UPDATE itemmonster SET associationid = 2537 WHERE associationId = 2371;
UPDATE itemmonster SET associationid = 2537 WHERE associationId = 2423;

GO

delete from Association where AssociationId in (1733,
1132,
870,
2193,
8,
264,
2139,
2319,
2253,
1839,
839,
2235,
2403,
1473,
2243,
1463,
2315,
2567,
1573,
1418,
2321,
1967,
2323,
41,
42,
43,
44,
2325,
2327,
2329,
2331,
2247,
2011,
324,
1564,
2335,
2425,
2147,
376,
2555,
1151,
2043,
1460,
2203,
2293,
393,
1145,
68,
2153,
76,
741,
743,
744,
383,
955,
1300,
1159,
1749,
2563,
1451,
102,
2339,
2341,
2427,
2137,
2405,
107,
372,
1124,
1305,
2569,
2571,
2347,
2421,
1560,
1799,
2573,
2349,
2575,
2551,
2353,
2429,
2407,
281,
2743,
2355,
745,
985,
1364,
2577,
285,
2357,
2431,
2359,
2433,
2435,
729,
730,
963,
1689,
1361,
1433,
164,
167,
804,
802,
803,
773,
1185,
2399,
1691,
2559,
1693,
177,
2233,
929,
1439,
119,
1723,
1877,
2113,
1503,
1983,
1313,
1367,
2561,
1709,
2557,
219,
1018,
1861,
2565,
2369,
1014,
1627,
750,
1697,
1795,
2553,
2397,
301,
2123,
1212,
250,
1261,
732,
734,
733,
2371,
2423
);

GO