December 23, 2011 at 12:08 pm
I just had to post this because I can hardly believe my eyes. That's right boys and girls, 1999 paramters.:w00t: And yes, we do have serious performance problems with this particular piece of vendor software.
DECLARE @p1 INT
EXEC sp_prepexec @p1 OUTPUT,
N'@P0 bigint,@P1 bigint,@P2 bigint,@P3 bigint,@P4 bigint,@P5 bigint,@P6 bigint,@P7 bigint,@P8 bigint,@P9 bigint,
@P10 bigint,@P11 bigint,@P12 bigint,@P13 bigint,@P14 bigint,@P15 bigint,@P16 bigint,@P17 bigint,@P18 bigint,@P19 bigint,
@P20 bigint,@P21 bigint,@P22 bigint,@P23 bigint,@P24 bigint,@P25 bigint,@P26 bigint,@P27 bigint,@P28 bigint,@P29 bigint,
@P30 bigint,@P31 bigint,@P32 bigint,@P33 bigint,@P34 bigint,@P35 bigint,@P36 bigint,@P37 bigint,@P38 bigint,@P39 bigint,
@P40 bigint,@P41 bigint,@P42 bigint,@P43 bigint,@P44 bigint,@P45 bigint,@P46 bigint,@P47 bigint,@P48 bigint,@P49 bigint,
@P50 bigint,@P51 bigint,@P52 bigint,@P53 bigint,@P54 bigint,@P55 bigint,@P56 bigint,@P57 bigint,@P58 bigint,@P59 bigint,
@P60 bigint,@P61 bigint,@P62 bigint,@P63 bigint,@P64 bigint,@P65 bigint,@P66 bigint,@P67 bigint,@P68 bigint,@P69 bigint,
@P70 bigint,@P71 bigint,@P72 bigint,@P73 bigint,@P74 bigint,@P75 bigint,@P76 bigint,@P77 bigint,@P78 bigint,@P79 bigint,
@P80 bigint,@P81 bigint,@P82 bigint,@P83 bigint,@P84 bigint,@P85 bigint,@P86 bigint,@P87 bigint,@P88 bigint,@P89 bigint,
@P90 bigint,@P91 bigint,@P92 bigint,@P93 bigint,@P94 bigint,@P95 bigint,@P96 bigint,@P97 bigint,@P98 bigint,@P99 bigint,
@P100 bigint,@P101 bigint,@P102 bigint,@P103 bigint,@P104 bigint,@P105 bigint,@P106 bigint,@P107 bigint,@P108 bigint,
@P109 bigint,@P110 bigint,@P111 bigint,@P112 bigint,@P113 bigint,@P114 bigint,@P115 bigint,@P116 bigint,@P117 bigint,
@P118 bigint,@P119 bigint,@P120 bigint,@P121 bigint,@P122 bigint,@P123 bigint,@P124 bigint,@P125 bigint,@P126 bigint,
@P127 bigint,@P128 bigint,@P129 bigint,@P130 bigint,@P131 bigint,@P132 bigint,@P133 bigint,@P134 bigint,@P135 bigint,
@P136 bigint,@P137 bigint,@P138 bigint,@P139 bigint,@P140 bigint,@P141 bigint,@P142 bigint,@P143 bigint,@P144 bigint,
@P145 bigint,@P146 bigint,@P147 bigint,@P148 bigint,@P149 bigint,@P150 bigint,@P151 bigint,@P152 bigint,@P153 bigint,
@P154 bigint,@P155 bigint,@P156 bigint,@P157 bigint,@P158 bigint,@P159 bigint,@P160 bigint,@P161 bigint,@P162 bigint,
@P163 bigint,@P164 bigint,@P165 bigint,@P166 bigint,@P167 bigint,@P168 bigint,@P169 bigint,@P170 bigint,@P171 bigint,
@P172 bigint,@P173 bigint,@P174 bigint,@P175 bigint,@P176 bigint,@P177 bigint,@P178 bigint,@P179 bigint,@P180 bigint,
@P181 bigint,@P182 bigint,@P183 bigint,@P184 bigint,@P185 bigint,@P186 bigint,@P187 bigint,@P188 bigint,@P189 bigint,
@P190 bigint,@P191 bigint,@P192 bigint,@P193 bigint,@P194 bigint,@P195 bigint,@P196 bigint,@P197 bigint,@P198 bigint,
@P199 bigint,@P200 bigint,@P201 bigint,@P202 bigint,@P203 bigint,@P204 bigint,@P205 bigint,@P206 bigint,@P207 bigint,
@P208 bigint,@P209 bigint,@P210 bigint,@P211 bigint,@P212 bigint,@P213 bigint,@P214 bigint,@P215 bigint,@P216 bigint,
@P217 bigint,@P218 bigint,@P219 bigint,@P220 bigint,@P221 bigint,@P222 bigint,@P223 bigint,@P224 bigint,@P225 bigint,
@P226 bigint,@P227 bigint,@P228 bigint,@P229 bigint,@P230 bigint,@P231 bigint,@P232 bigint,@P233 bigint,@P234 bigint,
@P235 bigint,@P236 bigint,@P237 bigint,@P238 bigint,@P239 bigint,@P240 bigint,@P241 bigint,@P242 bigint,@P243 bigint,
@P244 bigint,@P245 bigint,@P246 bigint,@P247 bigint,@P248 bigint,@P249 bigint,@P250 bigint,@P251 bigint,@P252 bigint,
@P253 bigint,@P254 bigint,@P255 bigint,@P256 bigint,@P257 bigint,@P258 bigint,@P259 bigint,@P260 bigint,@P261 bigint,
@P262 bigint,@P263 bigint,@P264 bigint,@P265 bigint,@P266 bigint,@P267 bigint,@P268 bigint,@P269 bigint,@P270 bigint,
@P271 bigint,@P272 bigint,@P273 bigint,@P274 bigint,@P275 bigint,@P276 bigint,@P277 bigint,@P278 bigint,@P279 bigint,
@P280 bigint,@P281 bigint,@P282 bigint,@P283 bigint,@P284 bigint,@P285 bigint,@P286 bigint,@P287 bigint,@P288 bigint,
@P289 bigint,@P290 bigint,@P291 bigint,@P292 bigint,@P293 bigint,@P294 bigint,@P295 bigint,@P296 bigint,@P297 bigint,
@P298 bigint,@P299 bigint,@P300 bigint,@P301 bigint,@P302 bigint,@P303 bigint,@P304 bigint,@P305 bigint,@P306 bigint,
@P307 bigint,@P308 bigint,@P309 bigint,@P310 bigint,@P311 bigint,@P312 bigint,@P313 bigint,@P314 bigint,@P315 bigint,
@P316 bigint,@P317 bigint,@P318 bigint,@P319 bigint,@P320 bigint,@P321 bigint,@P322 bigint,@P323 bigint,@P324 bigint,
@P325 bigint,@P326 bigint,@P327 bigint,@P328 bigint,@P329 bigint,@P330 bigint,@P331 bigint,@P332 bigint,@P333 bigint,
@P334 bigint,@P335 bigint,@P336 bigint,@P337 bigint,@P338 bigint,@P339 bigint,@P340 bigint,@P341 bigint,@P342 bigint,
@P343 bigint,@P344 bigint,@P345 bigint,@P346 bigint,@P347 bigint,@P348 bigint,@P349 bigint,@P350 bigint,@P351 bigint,
@P352 bigint,@P353 bigint,@P354 bigint,@P355 bigint,@P356 bigint,@P357 bigint,@P358 bigint,@P359 bigint,@P360 bigint,
@P361 bigint,@P362 bigint,@P363 bigint,@P364 bigint,@P365 bigint,@P366 bigint,@P367 bigint,@P368 bigint,@P369 bigint,
@P370 bigint,@P371 bigint,@P372 bigint,@P373 bigint,@P374 bigint,@P375 bigint,@P376 bigint,@P377 bigint,@P378 bigint,
@P379 bigint,@P380 bigint,@P381 bigint,@P382 bigint,@P383 bigint,@P384 bigint,@P385 bigint,@P386 bigint,@P387 bigint,
@P388 bigint,@P389 bigint,@P390 bigint,@P391 bigint,@P392 bigint,@P393 bigint,@P394 bigint,@P395 bigint,@P396 bigint,
@P397 bigint,@P398 bigint,@P399 bigint,@P400 bigint,@P401 bigint,@P402 bigint,@P403 bigint,@P404 bigint,@P405 bigint,
@P406 bigint,@P407 bigint,@P408 bigint,@P409 bigint,@P410 bigint,@P411 bigint,@P412 bigint,@P413 bigint,@P414 bigint,
@P415 bigint,@P416 bigint,@P417 bigint,@P418 bigint,@P419 bigint,@P420 bigint,@P421 bigint,@P422 bigint,@P423 bigint,
@P424 bigint,@P425 bigint,@P426 bigint,@P427 bigint,@P428 bigint,@P429 bigint,@P430 bigint,@P431 bigint,@P432 bigint,
@P433 bigint,@P434 bigint,@P435 bigint,@P436 bigint,@P437 bigint,@P438 bigint,@P439 bigint,@P440 bigint,@P441 bigint,
@P442 bigint,@P443 bigint,@P444 bigint,@P445 bigint,@P446 bigint,@P447 bigint,@P448 bigint,@P449 bigint,@P450 bigint,
@P451 bigint,@P452 bigint,@P453 bigint,@P454 bigint,@P455 bigint,@P456 bigint,@P457 bigint,@P458 bigint,@P459 bigint,
@P460 bigint,@P461 bigint,@P462 bigint,@P463 bigint,@P464 bigint,@P465 bigint,@P466 bigint,@P467 bigint,@P468 bigint,
@P469 bigint,@P470 bigint,@P471 bigint,@P472 bigint,@P473 bigint,@P474 bigint,@P475 bigint,@P476 bigint,@P477 bigint,
@P478 bigint,@P479 bigint,@P480 bigint,@P481 bigint,@P482 bigint,@P483 bigint,@P484 bigint,@P485 bigint,@P486 bigint,
@P487 bigint,@P488 bigint,@P489 bigint,@P490 bigint,@P491 bigint,@P492 bigint,@P493 bigint,@P494 bigint,@P495 bigint,
@P496 bigint,@P497 bigint,@P498 bigint,@P499 bigint,@P500 bigint,@P501 bigint,@P502 bigint,@P503 bigint,@P504 bigint,
@P505 bigint,@P506 bigint,@P507 bigint,@P508 bigint,@P509 bigint,@P510 bigint,@P511 bigint,@P512 bigint,@P513 bigint,
@P514 bigint,@P515 bigint,@P516 bigint,@P517 bigint,@P518 bigint,@P519 bigint,@P520 bigint,@P521 bigint,@P522 bigint,
@P523 bigint,@P524 bigint,@P525 bigint,@P526 bigint,@P527 bigint,@P528 bigint,@P529 bigint,@P530 bigint,@P531 bigint,
@P532 bigint,@P533 bigint,@P534 bigint,@P535 bigint,@P536 bigint,@P537 bigint,@P538 bigint,@P539 bigint,@P540 bigint,
@P541 bigint,@P542 bigint,@P543 bigint,@P544 bigint,@P545 bigint,@P546 bigint,@P547 bigint,@P548 bigint,@P549 bigint,
@P550 bigint,@P551 bigint,@P552 bigint,@P553 bigint,@P554 bigint,@P555 bigint,@P556 bigint,@P557 bigint,@P558 bigint,
@P559 bigint,@P560 bigint,@P561 bigint,@P562 bigint,@P563 bigint,@P564 bigint,@P565 bigint,@P566 bigint,@P567 bigint,
@P568 bigint,@P569 bigint,@P570 bigint,@P571 bigint,@P572 bigint,@P573 bigint,@P574 bigint,@P575 bigint,@P576 bigint,
@P577 bigint,@P578 bigint,@P579 bigint,@P580 bigint,@P581 bigint,@P582 bigint,@P583 bigint,@P584 bigint,@P585 bigint,
@P586 bigint,@P587 bigint,@P588 bigint,@P589 bigint,@P590 bigint,@P591 bigint,@P592 bigint,@P593 bigint,@P594 bigint,
@P595 bigint,@P596 bigint,@P597 bigint,@P598 bigint,@P599 bigint,@P600 bigint,@P601 bigint,@P602 bigint,@P603 bigint,
@P604 bigint,@P605 bigint,@P606 bigint,@P607 bigint,@P608 bigint,@P609 bigint,@P610 bigint,@P611 bigint,@P612 bigint,
@P613 bigint,@P614 bigint,@P615 bigint,@P616 bigint,@P617 bigint,@P618 bigint,@P619 bigint,@P620 bigint,@P621 bigint,
@P622 bigint,@P623 bigint,@P624 bigint,@P625 bigint,@P626 bigint,@P627 bigint,@P628 bigint,@P629 bigint,@P630 bigint,
@P631 bigint,@P632 bigint,@P633 bigint,@P634 bigint,@P635 bigint,@P636 bigint,@P637 bigint,@P638 bigint,@P639 bigint,
@P640 bigint,@P641 bigint,@P642 bigint,@P643 bigint,@P644 bigint,@P645 bigint,@P646 bigint,@P647 bigint,@P648 bigint,
@P649 bigint,@P650 bigint,@P651 bigint,@P652 bigint,@P653 bigint,@P654 bigint,@P655 bigint,@P656 bigint,@P657 bigint,
@P658 bigint,@P659 bigint,@P660 bigint,@P661 bigint,@P662 bigint,@P663 bigint,@P664 bigint,@P665 bigint,@P666 bigint,
@P667 bigint,@P668 bigint,@P669 bigint,@P670 bigint,@P671 bigint,@P672 bigint,@P673 bigint,@P674 bigint,@P675 bigint,
@P676 bigint,@P677 bigint,@P678 bigint,@P679 bigint,@P680 bigint,@P681 bigint,@P682 bigint,@P683 bigint,@P684 bigint,
@P685 bigint,@P686 bigint,@P687 bigint,@P688 bigint,@P689 bigint,@P690 bigint,@P691 bigint,@P692 bigint,@P693 bigint,
@P694 bigint,@P695 bigint,@P696 bigint,@P697 bigint,@P698 bigint,@P699 bigint,@P700 bigint,@P701 bigint,@P702 bigint,
@P703 bigint,@P704 bigint,@P705 bigint,@P706 bigint,@P707 bigint,@P708 bigint,@P709 bigint,@P710 bigint,@P711 bigint,
@P712 bigint,@P713 bigint,@P714 bigint,@P715 bigint,@P716 bigint,@P717 bigint,@P718 bigint,@P719 bigint,@P720 bigint,
@P721 bigint,@P722 bigint,@P723 bigint,@P724 bigint,@P725 bigint,@P726 bigint,@P727 bigint,@P728 bigint,@P729 bigint,
@P730 bigint,@P731 bigint,@P732 bigint,@P733 bigint,@P734 bigint,@P735 bigint,@P736 bigint,@P737 bigint,@P738 bigint,
@P739 bigint,@P740 bigint,@P741 bigint,@P742 bigint,@P743 bigint,@P744 bigint,@P745 bigint,@P746 bigint,@P747 bigint,
@P748 bigint,@P749 bigint,@P750 bigint,@P751 bigint,@P752 bigint,@P753 bigint,@P754 bigint,@P755 bigint,@P756 bigint,
@P757 bigint,@P758 bigint,@P759 bigint,@P760 bigint,@P761 bigint,@P762 bigint,@P763 bigint,@P764 bigint,@P765 bigint,
@P766 bigint,@P767 bigint,@P768 bigint,@P769 bigint,@P770 bigint,@P771 bigint,@P772 bigint,@P773 bigint,@P774 bigint,
@P775 bigint,@P776 bigint,@P777 bigint,@P778 bigint,@P779 bigint,@P780 bigint,@P781 bigint,@P782 bigint,@P783 bigint,
@P784 bigint,@P785 bigint,@P786 bigint,@P787 bigint,@P788 bigint,@P789 bigint,@P790 bigint,@P791 bigint,@P792 bigint,
@P793 bigint,@P794 bigint,@P795 bigint,@P796 bigint,@P797 bigint,@P798 bigint,@P799 bigint,@P800 bigint,@P801 bigint,
@P802 bigint,@P803 bigint,@P804 bigint,@P805 bigint,@P806 bigint,@P807 bigint,@P808 bigint,@P809 bigint,@P810 bigint,
@P811 bigint,@P812 bigint,@P813 bigint,@P814 bigint,@P815 bigint,@P816 bigint,@P817 bigint,@P818 bigint,@P819 bigint,
@P820 bigint,@P821 bigint,@P822 bigint,@P823 bigint,@P824 bigint,@P825 bigint,@P826 bigint,@P827 bigint,@P828 bigint,
@P829 bigint,@P830 bigint,@P831 bigint,@P832 bigint,@P833 bigint,@P834 bigint,@P835 bigint,@P836 bigint,@P837 bigint,
@P838 bigint,@P839 bigint,@P840 bigint,@P841 bigint,@P842 bigint,@P843 bigint,@P844 bigint,@P845 bigint,@P846 bigint,
@P847 bigint,@P848 bigint,@P849 bigint,@P850 bigint,@P851 bigint,@P852 bigint,@P853 bigint,@P854 bigint,@P855 bigint,
@P856 bigint,@P857 bigint,@P858 bigint,@P859 bigint,@P860 bigint,@P861 bigint,@P862 bigint,@P863 bigint,@P864 bigint,
@P865 bigint,@P866 bigint,@P867 bigint,@P868 bigint,@P869 bigint,@P870 bigint,@P871 bigint,@P872 bigint,@P873 bigint,
@P874 bigint,@P875 bigint,@P876 bigint,@P877 bigint,@P878 bigint,@P879 bigint,@P880 bigint,@P881 bigint,@P882 bigint,
@P883 bigint,@P884 bigint,@P885 bigint,@P886 bigint,@P887 bigint,@P888 bigint,@P889 bigint,@P890 bigint,@P891 bigint,
@P892 bigint,@P893 bigint,@P894 bigint,@P895 bigint,@P896 bigint,@P897 bigint,@P898 bigint,@P899 bigint,@P900 bigint,
@P901 bigint,@P902 bigint,@P903 bigint,@P904 bigint,@P905 bigint,@P906 bigint,@P907 bigint,@P908 bigint,@P909 bigint,
@P910 bigint,@P911 bigint,@P912 bigint,@P913 bigint,@P914 bigint,@P915 bigint,@P916 bigint,@P917 bigint,@P918 bigint,
@P919 bigint,@P920 bigint,@P921 bigint,@P922 bigint,@P923 bigint,@P924 bigint,@P925 bigint,@P926 bigint,@P927 bigint,
@P928 bigint,@P929 bigint,@P930 bigint,@P931 bigint,@P932 bigint,@P933 bigint,@P934 bigint,@P935 bigint,@P936 bigint,
@P937 bigint,@P938 bigint,@P939 bigint,@P940 bigint,@P941 bigint,@P942 bigint,@P943 bigint,@P944 bigint,@P945 bigint,
@P946 bigint,@P947 bigint,@P948 bigint,@P949 bigint,@P950 bigint,@P951 bigint,@P952 bigint,@P953 bigint,@P954 bigint,
@P955 bigint,@P956 bigint,@P957 bigint,@P958 bigint,@P959 bigint,@P960 bigint,@P961 bigint,@P962 bigint,@P963 bigint,
@P964 bigint,@P965 bigint,@P966 bigint,@P967 bigint,@P968 bigint,@P969 bigint,@P970 bigint,@P971 bigint,@P972 bigint,
@P973 bigint,@P974 bigint,@P975 bigint,@P976 bigint,@P977 bigint,@P978 bigint,@P979 bigint,@P980 bigint,@P981 bigint,
@P982 bigint,@P983 bigint,@P984 bigint,@P985 bigint,@P986 bigint,@P987 bigint,@P988 bigint,@P989 bigint,@P990 bigint,
@P991 bigint,@P992 bigint,@P993 bigint,@P994 bigint,@P995 bigint,@P996 bigint,@P997 bigint,@P998 bigint,@P999 bigint,
@P1000 bigint,@P1001 bigint,@P1002 bigint,@P1003 bigint,@P1004 bigint,@P1005 bigint,@P1006 bigint,@P1007 bigint,
@P1008 bigint,@P1009 bigint,@P1010 bigint,@P1011 bigint,@P1012 bigint,@P1013 bigint,@P1014 bigint,@P1015 bigint,
@P1016 bigint,@P1017 bigint,@P1018 bigint,@P1019 bigint,@P1020 bigint,@P1021 bigint,@P1022 bigint,@P1023 bigint,
@P1024 bigint,@P1025 bigint,@P1026 bigint,@P1027 bigint,@P1028 bigint,@P1029 bigint,@P1030 bigint,@P1031 bigint,
@P1032 bigint,@P1033 bigint,@P1034 bigint,@P1035 bigint,@P1036 bigint,@P1037 bigint,@P1038 bigint,@P1039 bigint,
@P1040 bigint,@P1041 bigint,@P1042 bigint,@P1043 bigint,@P1044 bigint,@P1045 bigint,@P1046 bigint,@P1047 bigint,
@P1048 bigint,@P1049 bigint,@P1050 bigint,@P1051 bigint,@P1052 bigint,@P1053 bigint,@P1054 bigint,@P1055 bigint,
@P1056 bigint,@P1057 bigint,@P1058 bigint,@P1059 bigint,@P1060 bigint,@P1061 bigint,@P1062 bigint,@P1063 bigint,
@P1064 bigint,@P1065 bigint,@P1066 bigint,@P1067 bigint,@P1068 bigint,@P1069 bigint,@P1070 bigint,@P1071 bigint,
@P1072 bigint,@P1073 bigint,@P1074 bigint,@P1075 bigint,@P1076 bigint,@P1077 bigint,@P1078 bigint,@P1079 bigint,
@P1080 bigint,@P1081 bigint,@P1082 bigint,@P1083 bigint,@P1084 bigint,@P1085 bigint,@P1086 bigint,@P1087 bigint,
@P1088 bigint,@P1089 bigint,@P1090 bigint,@P1091 bigint,@P1092 bigint,@P1093 bigint,@P1094 bigint,@P1095 bigint,
@P1096 bigint,@P1097 bigint,@P1098 bigint,@P1099 bigint,@P1100 bigint,@P1101 bigint,@P1102 bigint,@P1103 bigint,
@P1104 bigint,@P1105 bigint,@P1106 bigint,@P1107 bigint,@P1108 bigint,@P1109 bigint,@P1110 bigint,@P1111 bigint,
@P1112 bigint,@P1113 bigint,@P1114 bigint,@P1115 bigint,@P1116 bigint,@P1117 bigint,@P1118 bigint,@P1119 bigint,
@P1120 bigint,@P1121 bigint,@P1122 bigint,@P1123 bigint,@P1124 bigint,@P1125 bigint,@P1126 bigint,@P1127 bigint,
@P1128 bigint,@P1129 bigint,@P1130 bigint,@P1131 bigint,@P1132 bigint,@P1133 bigint,@P1134 bigint,@P1135 bigint,
@P1136 bigint,@P1137 bigint,@P1138 bigint,@P1139 bigint,@P1140 bigint,@P1141 bigint,@P1142 bigint,@P1143 bigint,
@P1144 bigint,@P1145 bigint,@P1146 bigint,@P1147 bigint,@P1148 bigint,@P1149 bigint,@P1150 bigint,@P1151 bigint,
@P1152 bigint,@P1153 bigint,@P1154 bigint,@P1155 bigint,@P1156 bigint,@P1157 bigint,@P1158 bigint,@P1159 bigint,
@P1160 bigint,@P1161 bigint,@P1162 bigint,@P1163 bigint,@P1164 bigint,@P1165 bigint,@P1166 bigint,@P1167 bigint,
@P1168 bigint,@P1169 bigint,@P1170 bigint,@P1171 bigint,@P1172 bigint,@P1173 bigint,@P1174 bigint,@P1175 bigint,
@P1176 bigint,@P1177 bigint,@P1178 bigint,@P1179 bigint,@P1180 bigint,@P1181 bigint,@P1182 bigint,@P1183 bigint,
@P1184 bigint,@P1185 bigint,@P1186 bigint,@P1187 bigint,@P1188 bigint,@P1189 bigint,@P1190 bigint,@P1191 bigint,
@P1192 bigint,@P1193 bigint,@P1194 bigint,@P1195 bigint,@P1196 bigint,@P1197 bigint,@P1198 bigint,@P1199 bigint,
@P1200 bigint,@P1201 bigint,@P1202 bigint,@P1203 bigint,@P1204 bigint,@P1205 bigint,@P1206 bigint,@P1207 bigint,
@P1208 bigint,@P1209 bigint,@P1210 bigint,@P1211 bigint,@P1212 bigint,@P1213 bigint,@P1214 bigint,@P1215 bigint,
@P1216 bigint,@P1217 bigint,@P1218 bigint,@P1219 bigint,@P1220 bigint,@P1221 bigint,@P1222 bigint,@P1223 bigint,
@P1224 bigint,@P1225 bigint,@P1226 bigint,@P1227 bigint,@P1228 bigint,@P1229 bigint,@P1230 bigint,@P1231 bigint,
@P1232 bigint,@P1233 bigint,@P1234 bigint,@P1235 bigint,@P1236 bigint,@P1237 bigint,@P1238 bigint,@P1239 bigint,
@P1240 bigint,@P1241 bigint,@P1242 bigint,@P1243 bigint,@P1244 bigint,@P1245 bigint,@P1246 bigint,@P1247 bigint,
@P1248 bigint,@P1249 bigint,@P1250 bigint,@P1251 bigint,@P1252 bigint,@P1253 bigint,@P1254 bigint,@P1255 bigint,
@P1256 bigint,@P1257 bigint,@P1258 bigint,@P1259 bigint,@P1260 bigint,@P1261 bigint,@P1262 bigint,@P1263 bigint,
@P1264 bigint,@P1265 bigint,@P1266 bigint,@P1267 bigint,@P1268 bigint,@P1269 bigint,@P1270 bigint,@P1271 bigint,
@P1272 bigint,@P1273 bigint,@P1274 bigint,@P1275 bigint,@P1276 bigint,@P1277 bigint,@P1278 bigint,@P1279 bigint,
@P1280 bigint,@P1281 bigint,@P1282 bigint,@P1283 bigint,@P1284 bigint,@P1285 bigint,@P1286 bigint,@P1287 bigint,
@P1288 bigint,@P1289 bigint,@P1290 bigint,@P1291 bigint,@P1292 bigint,@P1293 bigint,@P1294 bigint,@P1295 bigint,
@P1296 bigint,@P1297 bigint,@P1298 bigint,@P1299 bigint,@P1300 bigint,@P1301 bigint,@P1302 bigint,@P1303 bigint,
@P1304 bigint,@P1305 bigint,@P1306 bigint,@P1307 bigint,@P1308 bigint,@P1309 bigint,@P1310 bigint,@P1311 bigint,
@P1312 bigint,@P1313 bigint,@P1314 bigint,@P1315 bigint,@P1316 bigint,@P1317 bigint,@P1318 bigint,@P1319 bigint,
@P1320 bigint,@P1321 bigint,@P1322 bigint,@P1323 bigint,@P1324 bigint,@P1325 bigint,@P1326 bigint,@P1327 bigint,
@P1328 bigint,@P1329 bigint,@P1330 bigint,@P1331 bigint,@P1332 bigint,@P1333 bigint,@P1334 bigint,@P1335 bigint,
@P1336 bigint,@P1337 bigint,@P1338 bigint,@P1339 bigint,@P1340 bigint,@P1341 bigint,@P1342 bigint,@P1343 bigint,
@P1344 bigint,@P1345 bigint,@P1346 bigint,@P1347 bigint,@P1348 bigint,@P1349 bigint,@P1350 bigint,@P1351 bigint,
@P1352 bigint,@P1353 bigint,@P1354 bigint,@P1355 bigint,@P1356 bigint,@P1357 bigint,@P1358 bigint,@P1359 bigint,
@P1360 bigint,@P1361 bigint,@P1362 bigint,@P1363 bigint,@P1364 bigint,@P1365 bigint,@P1366 bigint,@P1367 bigint,
@P1368 bigint,@P1369 bigint,@P1370 bigint,@P1371 bigint,@P1372 bigint,@P1373 bigint,@P1374 bigint,@P1375 bigint,
@P1376 bigint,@P1377 bigint,@P1378 bigint,@P1379 bigint,@P1380 bigint,@P1381 bigint,@P1382 bigint,@P1383 bigint,
@P1384 bigint,@P1385 bigint,@P1386 bigint,@P1387 bigint,@P1388 bigint,@P1389 bigint,@P1390 bigint,@P1391 bigint,
@P1392 bigint,@P1393 bigint,@P1394 bigint,@P1395 bigint,@P1396 bigint,@P1397 bigint,@P1398 bigint,@P1399 bigint,
@P1400 bigint,@P1401 bigint,@P1402 bigint,@P1403 bigint,@P1404 bigint,@P1405 bigint,@P1406 bigint,@P1407 bigint,
@P1408 bigint,@P1409 bigint,@P1410 bigint,@P1411 bigint,@P1412 bigint,@P1413 bigint,@P1414 bigint,@P1415 bigint,
@P1416 bigint,@P1417 bigint,@P1418 bigint,@P1419 bigint,@P1420 bigint,@P1421 bigint,@P1422 bigint,@P1423 bigint,
@P1424 bigint,@P1425 bigint,@P1426 bigint,@P1427 bigint,@P1428 bigint,@P1429 bigint,@P1430 bigint,@P1431 bigint,
@P1432 bigint,@P1433 bigint,@P1434 bigint,@P1435 bigint,@P1436 bigint,@P1437 bigint,@P1438 bigint,@P1439 bigint,
@P1440 bigint,@P1441 bigint,@P1442 bigint,@P1443 bigint,@P1444 bigint,@P1445 bigint,@P1446 bigint,@P1447 bigint,
@P1448 bigint,@P1449 bigint,@P1450 bigint,@P1451 bigint,@P1452 bigint,@P1453 bigint,@P1454 bigint,@P1455 bigint,
@P1456 bigint,@P1457 bigint,@P1458 bigint,@P1459 bigint,@P1460 bigint,@P1461 bigint,@P1462 bigint,@P1463 bigint,
@P1464 bigint,@P1465 bigint,@P1466 bigint,@P1467 bigint,@P1468 bigint,@P1469 bigint,@P1470 bigint,@P1471 bigint,
@P1472 bigint,@P1473 bigint,@P1474 bigint,@P1475 bigint,@P1476 bigint,@P1477 bigint,@P1478 bigint,@P1479 bigint,
@P1480 bigint,@P1481 bigint,@P1482 bigint,@P1483 bigint,@P1484 bigint,@P1485 bigint,@P1486 bigint,@P1487 bigint,
@P1488 bigint,@P1489 bigint,@P1490 bigint,@P1491 bigint,@P1492 bigint,@P1493 bigint,@P1494 bigint,@P1495 bigint,
@P1496 bigint,@P1497 bigint,@P1498 bigint,@P1499 bigint,@P1500 bigint,@P1501 bigint,@P1502 bigint,@P1503 bigint,
@P1504 bigint,@P1505 bigint,@P1506 bigint,@P1507 bigint,@P1508 bigint,@P1509 bigint,@P1510 bigint,@P1511 bigint,
@P1512 bigint,@P1513 bigint,@P1514 bigint,@P1515 bigint,@P1516 bigint,@P1517 bigint,@P1518 bigint,@P1519 bigint,
@P1520 bigint,@P1521 bigint,@P1522 bigint,@P1523 bigint,@P1524 bigint,@P1525 bigint,@P1526 bigint,@P1527 bigint,
@P1528 bigint,@P1529 bigint,@P1530 bigint,@P1531 bigint,@P1532 bigint,@P1533 bigint,@P1534 bigint,@P1535 bigint,
@P1536 bigint,@P1537 bigint,@P1538 bigint,@P1539 bigint,@P1540 bigint,@P1541 bigint,@P1542 bigint,@P1543 bigint,
@P1544 bigint,@P1545 bigint,@P1546 bigint,@P1547 bigint,@P1548 bigint,@P1549 bigint,@P1550 bigint,@P1551 bigint,
@P1552 bigint,@P1553 bigint,@P1554 bigint,@P1555 bigint,@P1556 bigint,@P1557 bigint,@P1558 bigint,@P1559 bigint,
@P1560 bigint,@P1561 bigint,@P1562 bigint,@P1563 bigint,@P1564 bigint,@P1565 bigint,@P1566 bigint,@P1567 bigint,
@P1568 bigint,@P1569 bigint,@P1570 bigint,@P1571 bigint,@P1572 bigint,@P1573 bigint,@P1574 bigint,@P1575 bigint,
@P1576 bigint,@P1577 bigint,@P1578 bigint,@P1579 bigint,@P1580 bigint,@P1581 bigint,@P1582 bigint,@P1583 bigint,
@P1584 bigint,@P1585 bigint,@P1586 bigint,@P1587 bigint,@P1588 bigint,@P1589 bigint,@P1590 bigint,@P1591 bigint,
@P1592 bigint,@P1593 bigint,@P1594 bigint,@P1595 bigint,@P1596 bigint,@P1597 bigint,@P1598 bigint,@P1599 bigint,
@P1600 bigint,@P1601 bigint,@P1602 bigint,@P1603 bigint,@P1604 bigint,@P1605 bigint,@P1606 bigint,@P1607 bigint,
@P1608 bigint,@P1609 bigint,@P1610 bigint,@P1611 bigint,@P1612 bigint,@P1613 bigint,@P1614 bigint,@P1615 bigint,
@P1616 bigint,@P1617 bigint,@P1618 bigint,@P1619 bigint,@P1620 bigint,@P1621 bigint,@P1622 bigint,@P1623 bigint,
@P1624 bigint,@P1625 bigint,@P1626 bigint,@P1627 bigint,@P1628 bigint,@P1629 bigint,@P1630 bigint,@P1631 bigint,
@P1632 bigint,@P1633 bigint,@P1634 bigint,@P1635 bigint,@P1636 bigint,@P1637 bigint,@P1638 bigint,@P1639 bigint,
@P1640 bigint,@P1641 bigint,@P1642 bigint,@P1643 bigint,@P1644 bigint,@P1645 bigint,@P1646 bigint,@P1647 bigint,
@P1648 bigint,@P1649 bigint,@P1650 bigint,@P1651 bigint,@P1652 bigint,@P1653 bigint,@P1654 bigint,@P1655 bigint,
@P1656 bigint,@P1657 bigint,@P1658 bigint,@P1659 bigint,@P1660 bigint,@P1661 bigint,@P1662 bigint,@P1663 bigint,
@P1664 bigint,@P1665 bigint,@P1666 bigint,@P1667 bigint,@P1668 bigint,@P1669 bigint,@P1670 bigint,@P1671 bigint,
@P1672 bigint,@P1673 bigint,@P1674 bigint,@P1675 bigint,@P1676 bigint,@P1677 bigint,@P1678 bigint,@P1679 bigint,
@P1680 bigint,@P1681 bigint,@P1682 bigint,@P1683 bigint,@P1684 bigint,@P1685 bigint,@P1686 bigint,@P1687 bigint,
@P1688 bigint,@P1689 bigint,@P1690 bigint,@P1691 bigint,@P1692 bigint,@P1693 bigint,@P1694 bigint,@P1695 bigint,
@P1696 bigint,@P1697 bigint,@P1698 bigint,@P1699 bigint,@P1700 bigint,@P1701 bigint,@P1702 bigint,@P1703 bigint,
@P1704 bigint,@P1705 bigint,@P1706 bigint,@P1707 bigint,@P1708 bigint,@P1709 bigint,@P1710 bigint,@P1711 bigint,
@P1712 bigint,@P1713 bigint,@P1714 bigint,@P1715 bigint,@P1716 bigint,@P1717 bigint,@P1718 bigint,@P1719 bigint,
@P1720 bigint,@P1721 bigint,@P1722 bigint,@P1723 bigint,@P1724 bigint,@P1725 bigint,@P1726 bigint,@P1727 bigint,
@P1728 bigint,@P1729 bigint,@P1730 bigint,@P1731 bigint,@P1732 bigint,@P1733 bigint,@P1734 bigint,@P1735 bigint,
@P1736 bigint,@P1737 bigint,@P1738 bigint,@P1739 bigint,@P1740 bigint,@P1741 bigint,@P1742 bigint,@P1743 bigint,
@P1744 bigint,@P1745 bigint,@P1746 bigint,@P1747 bigint,@P1748 bigint,@P1749 bigint,@P1750 bigint,@P1751 bigint,
@P1752 bigint,@P1753 bigint,@P1754 bigint,@P1755 bigint,@P1756 bigint,@P1757 bigint,@P1758 bigint,@P1759 bigint,
@P1760 bigint,@P1761 bigint,@P1762 bigint,@P1763 bigint,@P1764 bigint,@P1765 bigint,@P1766 bigint,@P1767 bigint,
@P1768 bigint,@P1769 bigint,@P1770 bigint,@P1771 bigint,@P1772 bigint,@P1773 bigint,@P1774 bigint,@P1775 bigint,
@P1776 bigint,@P1777 bigint,@P1778 bigint,@P1779 bigint,@P1780 bigint,@P1781 bigint,@P1782 bigint,@P1783 bigint,
@P1784 bigint,@P1785 bigint,@P1786 bigint,@P1787 bigint,@P1788 bigint,@P1789 bigint,@P1790 bigint,@P1791 bigint,
@P1792 bigint,@P1793 bigint,@P1794 bigint,@P1795 bigint,@P1796 bigint,@P1797 bigint,@P1798 bigint,@P1799 bigint,
@P1800 bigint,@P1801 bigint,@P1802 bigint,@P1803 bigint,@P1804 bigint,@P1805 bigint,@P1806 bigint,@P1807 bigint,
@P1808 bigint,@P1809 bigint,@P1810 bigint,@P1811 bigint,@P1812 bigint,@P1813 bigint,@P1814 bigint,@P1815 bigint,
@P1816 bigint,@P1817 bigint,@P1818 bigint,@P1819 bigint,@P1820 bigint,@P1821 bigint,@P1822 bigint,@P1823 bigint,
@P1824 bigint,@P1825 bigint,@P1826 bigint,@P1827 bigint,@P1828 bigint,@P1829 bigint,@P1830 bigint,@P1831 bigint,
@P1832 bigint,@P1833 bigint,@P1834 bigint,@P1835 bigint,@P1836 bigint,@P1837 bigint,@P1838 bigint,@P1839 bigint,
@P1840 bigint,@P1841 bigint,@P1842 bigint,@P1843 bigint,@P1844 bigint,@P1845 bigint,@P1846 bigint,@P1847 bigint,
@P1848 bigint,@P1849 bigint,@P1850 bigint,@P1851 bigint,@P1852 bigint,@P1853 bigint,@P1854 bigint,@P1855 bigint,
@P1856 bigint,@P1857 bigint,@P1858 bigint,@P1859 bigint,@P1860 bigint,@P1861 bigint,@P1862 bigint,@P1863 bigint,
@P1864 bigint,@P1865 bigint,@P1866 bigint,@P1867 bigint,@P1868 bigint,@P1869 bigint,@P1870 bigint,@P1871 bigint,
@P1872 bigint,@P1873 bigint,@P1874 bigint,@P1875 bigint,@P1876 bigint,@P1877 bigint,@P1878 bigint,@P1879 bigint,
@P1880 bigint,@P1881 bigint,@P1882 bigint,@P1883 bigint,@P1884 bigint,@P1885 bigint,@P1886 bigint,@P1887 bigint,
@P1888 bigint,@P1889 bigint,@P1890 bigint,@P1891 bigint,@P1892 bigint,@P1893 bigint,@P1894 bigint,@P1895 bigint,
@P1896 bigint,@P1897 bigint,@P1898 bigint,@P1899 bigint,@P1900 bigint,@P1901 bigint,@P1902 bigint,@P1903 bigint,
@P1904 bigint,@P1905 bigint,@P1906 bigint,@P1907 bigint,@P1908 bigint,@P1909 bigint,@P1910 bigint,@P1911 bigint,
@P1912 bigint,@P1913 bigint,@P1914 bigint,@P1915 bigint,@P1916 bigint,@P1917 bigint,@P1918 bigint,@P1919 bigint,
@P1920 bigint,@P1921 bigint,@P1922 bigint,@P1923 bigint,@P1924 bigint,@P1925 bigint,@P1926 bigint,@P1927 bigint,
@P1928 bigint,@P1929 bigint,@P1930 bigint,@P1931 bigint,@P1932 bigint,@P1933 bigint,@P1934 bigint,@P1935 bigint,
@P1936 bigint,@P1937 bigint,@P1938 bigint,@P1939 bigint,@P1940 bigint,@P1941 bigint,@P1942 bigint,@P1943 bigint,
@P1944 bigint,@P1945 bigint,@P1946 bigint,@P1947 bigint,@P1948 bigint,@P1949 bigint,@P1950 bigint,@P1951 bigint,
@P1952 bigint,@P1953 bigint,@P1954 bigint,@P1955 bigint,@P1956 bigint,@P1957 bigint,@P1958 bigint,@P1959 bigint,
@P1960 bigint,@P1961 bigint,@P1962 bigint,@P1963 bigint,@P1964 bigint,@P1965 bigint,@P1966 bigint,@P1967 bigint,
@P1968 bigint,@P1969 bigint,@P1970 bigint,@P1971 bigint,@P1972 bigint,@P1973 bigint,@P1974 bigint,@P1975 bigint,
@P1976 bigint,@P1977 bigint,@P1978 bigint,@P1979 bigint,@P1980 bigint,@P1981 bigint,@P1982 bigint,@P1983 bigint,
@P1984 bigint,@P1985 bigint,@P1986 bigint,@P1987 bigint,@P1988 bigint,@P1989 bigint,@P1990 bigint,@P1991 bigint,
@P1992 bigint,@P1993 bigint,@P1994 bigint,@P1995 bigint,@P1996 bigint,@P1997 bigint,@P1998 bigint,@P1999 bigint',
N'select activation0_.ID as col_0_0_, licensefil2_.ID as col_1_0_,
licensefil2_.NAME as col_2_0_,
licensefil2_.DESCRIPTION as col_3_0_,
licensefil2_.LICENSE_STORAGE_TYPE as col_4_0_,
licensetec3_.ID as col_5_0_,
licensetex1_.LICENSE_TEXT as col_6_0_,
licensetex1_.BINARY_LICENSE as col_7_0_
from OPS_ACTIVATION_INSTANCE activation0_
inner join OPS_FULFILLMENT_LICENSE_TEXT licensetex1_ on activation0_.ID=licensetex1_.ACTIVATION_INST_ID
inner join OPS_LICENSE_FILE_DEFINITIONS licensefil2_ on licensetex1_.LICENSE_FILE_DEFINITION_ID=licensefil2_.ID
inner join OPS_LICENSE_TECHNOLOGY licensetec3_ on licensefil2_.LICENSE_TECHNOLOGY_ID=licensetec3_.ID
where activation0_.FULFILLMENT_TYPE in (''bo.constants.fulfillment.type.certificate'', ''bo.constants.fulfillment.type.trusted'', ''bo.constants.fulfillment.type.custom'')
and (activation0_.ID in (@P0 , @P1 , @P2 , @P3 , @P4 , @P5 , @P6 , @P7 , @P8 , @P9 , @P10 , @P11 , @P12 , @P13 , @P14 , @P15 , @P16 , @P17 , @P18 , @P19 ,
@P20 , @P21 , @P22 , @P23 , @P24 , @P25 , @P26 , @P27 , @P28 , @P29 , @P30 , @P31 , @P32 , @P33 , @P34 , @P35 , @P36 , @P37 , @P38 , @P39 , @P40 , @P41 ,
@P42 , @P43 , @P44 , @P45 , @P46 , @P47 , @P48 , @P49 , @P50 , @P51 , @P52 , @P53 , @P54 , @P55 , @P56 , @P57 , @P58 , @P59 , @P60 , @P61 , @P62 , @P63 ,
@P64 , @P65 , @P66 , @P67 , @P68 , @P69 , @P70 , @P71 , @P72 , @P73 , @P74 , @P75 , @P76 , @P77 , @P78 , @P79 , @P80 , @P81 , @P82 , @P83 , @P84 , @P85 ,
@P86 , @P87 , @P88 , @P89 , @P90 , @P91 , @P92 , @P93 , @P94 , @P95 , @P96 , @P97 , @P98 , @P99 , @P100 , @P101 , @P102 , @P103 , @P104 , @P105 , @P106 ,
@P107 , @P108 , @P109 , @P110 , @P111 , @P112 , @P113 , @P114 , @P115 , @P116 , @P117 , @P118 , @P119 , @P120 , @P121 , @P122 , @P123 , @P124 , @P125 ,
@P126 , @P127 , @P128 , @P129 , @P130 , @P131 , @P132 , @P133 , @P134 , @P135 , @P136 , @P137 , @P138 , @P139 , @P140 , @P141 , @P142 , @P143 , @P144 ,
@P145 , @P146 , @P147 , @P148 , @P149 , @P150 , @P151 , @P152 , @P153 , @P154 , @P155 , @P156 , @P157 , @P158 , @P159 , @P160 , @P161 , @P162 , @P163 ,
@P164 , @P165 , @P166 , @P167 , @P168 , @P169 , @P170 , @P171 , @P172 , @P173 , @P174 , @P175 , @P176 , @P177 , @P178 , @P179 , @P180 , @P181 , @P182 ,
@P183 , @P184 , @P185 , @P186 , @P187 , @P188 , @P189 , @P190 , @P191 , @P192 , @P193 , @P194 , @P195 , @P196 , @P197 , @P198 , @P199 , @P200 , @P201 ,
@P202 , @P203 , @P204 , @P205 , @P206 , @P207 , @P208 , @P209 , @P210 , @P211 , @P212 , @P213 , @P214 , @P215 , @P216 , @P217 , @P218 , @P219 , @P220 ,
@P221 , @P222 , @P223 , @P224 , @P225 , @P226 , @P227 , @P228 , @P229 , @P230 , @P231 , @P232 , @P233 , @P234 , @P235 , @P236 , @P237 , @P238 , @P239 ,
@P240 , @P241 , @P242 , @P243 , @P244 , @P245 , @P246 , @P247 , @P248 , @P249 , @P250 , @P251 , @P252 , @P253 , @P254 , @P255 , @P256 , @P257 , @P258 ,
@P259 , @P260 , @P261 , @P262 , @P263 , @P264 , @P265 , @P266 , @P267 , @P268 , @P269 , @P270 , @P271 , @P272 , @P273 , @P274 , @P275 , @P276 , @P277 ,
@P278 , @P279 , @P280 , @P281 , @P282 , @P283 , @P284 , @P285 , @P286 , @P287 , @P288 , @P289 , @P290 , @P291 , @P292 , @P293 , @P294 , @P295 , @P296 ,
@P297 , @P298 , @P299 , @P300 , @P301 , @P302 , @P303 , @P304 , @P305 , @P306 , @P307 , @P308 , @P309 , @P310 , @P311 , @P312 , @P313 , @P314 , @P315 ,
@P316 , @P317 , @P318 , @P319 , @P320 , @P321 , @P322 , @P323 , @P324 , @P325 , @P326 , @P327 , @P328 , @P329 , @P330 , @P331 , @P332 , @P333 , @P334 ,
@P335 , @P336 , @P337 , @P338 , @P339 , @P340 , @P341 , @P342 , @P343 , @P344 , @P345 , @P346 , @P347 , @P348 , @P349 , @P350 , @P351 , @P352 , @P353 ,
@P354 , @P355 , @P356 , @P357 , @P358 , @P359 , @P360 , @P361 , @P362 , @P363 , @P364 , @P365 , @P366 , @P367 , @P368 , @P369 , @P370 , @P371 , @P372 ,
@P373 , @P374 , @P375 , @P376 , @P377 , @P378 , @P379 , @P380 , @P381 , @P382 , @P383 , @P384 , @P385 , @P386 , @P387 , @P388 , @P389 , @P390 , @P391 ,
@P392 , @P393 , @P394 , @P395 , @P396 , @P397 , @P398 , @P399 , @P400 , @P401 , @P402 , @P403 , @P404 , @P405 , @P406 , @P407 , @P408 , @P409 , @P410 ,
@P411 , @P412 , @P413 , @P414 , @P415 , @P416 , @P417 , @P418 , @P419 , @P420 , @P421 , @P422 , @P423 , @P424 , @P425 , @P426 , @P427 , @P428 , @P429 ,
@P430 , @P431 , @P432 , @P433 , @P434 , @P435 , @P436 , @P437 , @P438 , @P439 , @P440 , @P441 , @P442 , @P443 , @P444 , @P445 , @P446 , @P447 , @P448 ,
@P449 , @P450 , @P451 , @P452 , @P453 , @P454 , @P455 , @p456 , @P457 , @P458 , @P459 , @P460 , @P461 , @P462 , @P463 , @P464 , @P465 , @P466 , @P467 ,
@P468 , @P469 , @P470 , @P471 , @P472 , @P473 , @P474 , @P475 , @P476 , @P477 , @P478 , @P479 , @P480 , @P481 , @P482 , @P483 , @P484 , @P485 , @P486 ,
@P487 , @P488 , @P489 , @P490 , @P491 , @P492 , @P493 , @P494 , @P495 , @P496 , @P497 , @P498 , @P499 , @P500 , @P501 , @P502 , @P503 , @P504 , @P505 ,
@P506 , @P507 , @P508 , @P509 , @P510 , @P511 , @P512 , @P513 , @P514 , @P515 , @P516 , @P517 , @P518 , @P519 , @P520 , @P521 , @P522 , @P523 , @P524 ,
@P525 , @P526 , @P527 , @P528 , @P529 , @P530 , @P531 , @P532 , @P533 , @P534 , @P535 , @P536 , @P537 , @P538 , @P539 , @P540 , @P541 , @P542 , @P543 ,
@P544 , @P545 , @P546 , @P547 , @P548 , @P549 , @P550 , @P551 , @P552 , @P553 , @P554 , @P555 , @P556 , @P557 , @P558 , @P559 , @P560 , @P561 , @P562 ,
@P563 , @P564 , @P565 , @P566 , @P567 , @P568 , @P569 , @P570 , @P571 , @P572 , @P573 , @P574 , @P575 , @P576 , @P577 , @P578 , @P579 , @P580 , @P581 ,
@P582 , @P583 , @P584 , @P585 , @P586 , @P587 , @P588 , @P589 , @P590 , @P591 , @P592 , @P593 , @P594 , @P595 , @P596 , @P597 , @P598 , @P599 , @P600 ,
@P601 , @P602 , @P603 , @P604 , @P605 , @P606 , @P607 , @P608 , @P609 , @P610 , @P611 , @P612 , @P613 , @P614 , @P615 , @P616 , @P617 , @P618 , @P619 ,
@P620 , @P621 , @P622 , @P623 , @P624 , @P625 , @P626 , @P627 , @P628 , @P629 , @P630 , @P631 , @P632 , @P633 , @P634 , @P635 , @P636 , @P637 , @P638 ,
@P639 , @P640 , @P641 , @P642 , @P643 , @P644 , @P645 , @P646 , @P647 , @P648 , @P649 , @P650 , @P651 , @P652 , @P653 , @P654 , @P655 , @P656 , @P657 ,
@P658 , @P659 , @P660 , @P661 , @P662 , @P663 , @P664 , @P665 , @P666 , @P667 , @P668 , @P669 , @P670 , @P671 , @P672 , @P673 , @P674 , @P675 , @P676 ,
@P677 , @P678 , @P679 , @P680 , @P681 , @P682 , @P683 , @P684 , @P685 , @P686 , @P687 , @P688 , @P689 , @P690 , @P691 , @P692 , @P693 , @P694 , @P695 ,
@P696 , @P697 , @P698 , @P699 , @P700 , @P701 , @P702 , @P703 , @P704 , @P705 , @P706 , @P707 , @P708 , @P709 , @P710 , @P711 , @P712 , @P713 , @P714 ,
@P715 , @P716 , @P717 , @P718 , @P719 , @P720 , @P721 , @P722 , @P723 , @P724 , @P725 , @P726 , @P727 , @P728 , @P729 , @P730 , @P731 , @P732 , @P733 ,
@P734 , @P735 , @P736 , @P737 , @P738 , @P739 , @P740 , @P741 , @P742 , @P743 , @P744 , @P745 , @P746 , @P747 , @P748 , @P749 , @P750 , @P751 , @P752 ,
@P753 , @P754 , @P755 , @P756 , @P757 , @P758 , @P759 , @P760 , @P761 , @P762 , @P763 , @P764 , @P765 , @P766 , @P767 , @P768 , @P769 , @P770 , @P771 ,
@P772 , @P773 , @P774 , @P775 , @P776 , @P777 , @P778 , @P779 , @P780 , @P781 , @P782 , @P783 , @P784 , @P785 , @P786 , @P787 , @P788 , @P789 , @P790 ,
@P791 , @P792 , @P793 , @P794 , @P795 , @P796 , @P797 , @P798 , @P799 , @P800 , @P801 , @P802 , @P803 , @P804 , @P805 , @P806 , @P807 , @P808 , @P809 ,
@P810 , @P811 , @P812 , @P813 , @P814 , @P815 , @P816 , @P817 , @P818 , @P819 , @P820 , @P821 , @P822 , @P823 , @P824 , @P825 , @P826 , @P827 , @P828 ,
@P829 , @P830 , @P831 , @P832 , @P833 , @P834 , @P835 , @P836 , @P837 , @P838 , @P839 , @P840 , @P841 , @P842 , @P843 , @P844 , @P845 , @P846 , @P847 ,
@P848 , @P849 , @P850 , @P851 , @P852 , @P853 , @P854 , @P855 , @P856 , @P857 , @P858 , @P859 , @P860 , @P861 , @P862 , @P863 , @P864 , @P865 , @P866 ,
@P867 , @P868 , @P869 , @P870 , @P871 , @P872 , @P873 , @P874 , @P875 , @P876 , @P877 , @P878 , @P879 , @P880 , @P881 , @P882 , @P883 , @P884 , @P885 ,
@P886 , @P887 , @p888 , @P889 , @P890 , @P891 , @P892 , @P893 , @P894 , @P895 , @P896 , @P897 , @P898 , @P899 , @P900 , @P901 , @P902 , @P903 , @P904 ,
@P905 , @P906 , @P907 , @P908 , @P909 , @P910 , @P911 , @P912 , @P913 , @P914 , @P915 , @P916 , @P917 , @P918 , @P919 , @P920 , @P921 , @P922 , @P923 ,
@P924 , @P925 , @P926 , @P927 , @P928 , @P929 , @P930 , @P931 , @P932 , @P933 , @P934 , @P935 , @P936 , @P937 , @P938 , @P939 , @P940 , @P941 , @P942 ,
@P943 , @P944 , @P945 , @P946 , @P947 , @P948 , @P949 , @P950 , @P951 , @P952 , @P953 , @P954 , @P955 , @P956 , @P957 , @P958 , @P959 , @P960 , @P961 ,
@P962 , @P963 , @P964 , @P965 , @P966 , @P967 , @P968 , @P969 , @P970 , @P971 , @P972 , @P973 , @P974 , @P975 , @P976 , @P977 , @P978 , @P979 , @P980 ,
@P981 , @P982 , @P983 , @P984 , @P985 , @P986 , @P987 , @P988 , @P989 , @P990 , @P991 , @P992 , @P993 , @P994 , @P995 , @P996 , @P997 , @P998 , @P999 ,
@P1000 , @P1001 , @P1002 , @P1003 , @P1004 , @P1005 , @P1006 , @P1007 , @P1008 , @P1009 , @P1010 , @P1011 , @P1012 , @P1013 , @P1014 , @P1015 , @P1016 ,
@P1017 , @P1018 , @P1019 , @P1020 , @P1021 , @P1022 , @P1023 , @P1024 , @P1025 , @P1026 , @P1027 , @P1028 , @P1029 , @P1030 , @P1031 , @P1032 , @P1033 ,
@P1034 , @P1035 , @P1036 , @P1037 , @P1038 , @P1039 , @P1040 , @P1041 , @P1042 , @P1043 , @P1044 , @P1045 , @P1046 , @P1047 , @P1048 , @P1049 , @P1050 ,
@P1051 , @P1052 , @P1053 , @P1054 , @P1055 , @P1056 , @P1057 , @P1058 , @P1059 , @P1060 , @P1061 , @P1062 , @P1063 , @P1064 , @P1065 , @P1066 , @P1067 ,
@P1068 , @P1069 , @P1070 , @P1071 , @P1072 , @P1073 , @P1074 , @P1075 , @P1076 , @P1077 , @P1078 , @P1079 , @P1080 , @P1081 , @P1082 , @P1083 , @P1084 ,
@P1085 , @P1086 , @P1087 , @P1088 , @P1089 , @P1090 , @P1091 , @P1092 , @P1093 , @P1094 , @P1095 , @P1096 , @P1097 , @P1098 , @P1099 , @P1100 , @P1101 ,
@P1102 , @P1103 , @P1104 , @P1105 , @P1106 , @P1107 , @P1108 , @P1109 , @P1110 , @P1111 , @P1112 , @P1113 , @P1114 , @P1115 , @P1116 , @P1117 , @P1118 ,
@P1119 , @P1120 , @P1121 , @P1122 , @P1123 , @P1124 , @P1125 , @P1126 , @P1127 , @P1128 , @P1129 , @P1130 , @P1131 , @P1132 , @P1133 , @P1134 , @P1135 ,
@P1136 , @P1137 , @P1138 , @P1139 , @P1140 , @P1141 , @P1142 , @P1143 , @P1144 , @P1145 , @P1146 , @P1147 , @P1148 , @P1149 , @P1150 , @P1151 , @P1152 ,
@P1153 , @P1154 , @P1155 , @P1156 , @P1157 , @P1158 , @P1159 , @P1160 , @P1161 , @P1162 , @P1163 , @P1164 , @P1165 , @P1166 , @P1167 , @P1168 , @P1169 ,
@P1170 , @P1171 , @P1172 , @P1173 , @P1174 , @P1175 , @P1176 , @P1177 , @P1178 , @P1179 , @P1180 , @P1181 , @P1182 , @P1183 , @P1184 , @P1185 , @P1186 ,
@P1187 , @P1188 , @P1189 , @P1190 , @P1191 , @P1192 , @P1193 , @P1194 , @P1195 , @P1196 , @P1197 , @P1198 , @P1199 , @P1200 , @P1201 , @P1202 , @P1203 ,
@P1204 , @P1205 , @P1206 , @P1207 , @P1208 , @P1209 , @P1210 , @P1211 , @P1212 , @P1213 , @P1214 , @P1215 , @P1216 , @P1217 , @P1218 , @P1219 , @P1220 ,
@P1221 , @P1222 , @P1223 , @P1224 , @P1225 , @P1226 , @P1227 , @P1228 , @P1229 , @P1230 , @P1231 , @P1232 , @P1233 , @P1234 , @P1235 , @P1236 , @P1237 ,
@P1238 , @P1239 , @P1240 , @P1241 , @P1242 , @P1243 , @P1244 , @P1245 , @P1246 , @P1247 , @P1248 , @P1249 , @P1250 , @P1251 , @P1252 , @P1253 , @P1254 ,
@P1255 , @P1256 , @P1257 , @P1258 , @P1259 , @P1260 , @P1261 , @P1262 , @P1263 , @P1264 , @P1265 , @P1266 , @P1267 , @P1268 , @P1269 , @P1270 , @P1271 ,
@P1272 , @P1273 , @P1274 , @P1275 , @P1276 , @P1277 , @P1278 , @P1279 , @P1280 , @P1281 , @P1282 , @P1283 , @P1284 , @P1285 , @P1286 , @P1287 , @P1288 ,
@P1289 , @P1290 , @P1291 , @p1292 , @P1293 , @P1294 , @P1295 , @P1296 , @P1297 , @P1298 , @P1299 , @P1300 , @P1301 , @P1302 , @P1303 , @P1304 , @P1305 ,
@P1306 , @P1307 , @P1308 , @P1309 , @P1310 , @P1311 , @P1312 , @P1313 , @P1314 , @P1315 , @P1316 , @P1317 , @P1318 , @P1319 , @P1320 , @P1321 , @P1322 ,
@P1323 , @P1324 , @P1325 , @P1326 , @P1327 , @P1328 , @P1329 , @P1330 , @P1331 , @P1332 , @P1333 , @P1334 , @P1335 , @P1336 , @P1337 , @P1338 , @P1339 ,
@P1340 , @P1341 , @P1342 , @P1343 , @P1344 , @P1345 , @P1346 , @P1347 , @P1348 , @P1349 , @P1350 , @P1351 , @P1352 , @P1353 , @P1354 , @P1355 , @P1356 ,
@P1357 , @P1358 , @P1359 , @P1360 , @P1361 , @P1362 , @P1363 , @P1364 , @P1365 , @P1366 , @P1367 , @P1368 , @P1369 , @P1370 , @P1371 , @P1372 , @P1373 ,
@P1374 , @P1375 , @P1376 , @P1377 , @P1378 , @P1379 , @P1380 , @P1381 , @P1382 , @P1383 , @P1384 , @P1385 , @P1386 , @P1387 , @P1388 , @P1389 , @P1390 ,
@P1391 , @P1392 , @P1393 , @P1394 , @P1395 , @P1396 , @P1397 , @P1398 , @P1399 , @P1400 , @P1401 , @P1402 , @P1403 , @P1404 , @P1405 , @P1406 , @P1407 ,
@P1408 , @P1409 , @P1410 , @P1411 , @P1412 , @P1413 , @P1414 , @P1415 , @P1416 , @P1417 , @P1418 , @P1419 , @P1420 , @P1421 , @P1422 , @P1423 , @P1424 ,
@P1425 , @P1426 , @P1427 , @P1428 , @P1429 , @P1430 , @P1431 , @P1432 , @P1433 , @P1434 , @P1435 , @P1436 , @P1437 , @P1438 , @P1439 , @P1440 , @P1441 ,
@P1442 , @P1443 , @P1444 , @P1445 , @P1446 , @P1447 , @P1448 , @P1449 , @P1450 , @P1451 , @P1452 , @P1453 , @P1454 , @P1455 , @P1456 , @P1457 , @P1458 ,
@P1459 , @P1460 , @P1461 , @P1462 , @P1463 , @P1464 , @P1465 , @P1466 , @P1467 , @P1468 , @P1469 , @P1470 , @P1471 , @P1472 , @P1473 , @P1474 , @P1475 ,
@P1476 , @P1477 , @P1478 , @P1479 , @P1480 , @P1481 , @P1482 , @P1483 , @P1484 , @P1485 , @P1486 , @P1487 , @P1488 , @P1489 , @P1490 , @P1491 , @P1492 ,
@P1493 , @P1494 , @P1495 , @P1496 , @P1497 , @P1498 , @P1499 , @P1500 , @P1501 , @P1502 , @P1503 , @P1504 , @P1505 , @P1506 , @P1507 , @P1508 , @P1509 ,
@P1510 , @P1511 , @P1512 , @P1513 , @P1514 , @P1515 , @P1516 , @P1517 , @P1518 , @P1519 , @P1520 , @P1521 , @P1522 , @P1523 , @P1524 , @P1525 , @P1526 ,
@P1527 , @P1528 , @P1529 , @P1530 , @P1531 , @P1532 , @P1533 , @P1534 , @P1535 , @P1536 , @P1537 , @P1538 , @P1539 , @P1540 , @P1541 , @P1542 , @P1543 ,
@P1544 , @P1545 , @P1546 , @P1547 , @P1548 , @P1549 , @P1550 , @P1551 , @P1552 , @P1553 , @P1554 , @P1555 , @P1556 , @P1557 , @P1558 , @P1559 , @P1560 ,
@P1561 , @P1562 , @P1563 , @P1564 , @P1565 , @P1566 , @P1567 , @P1568 , @P1569 , @P1570 , @P1571 , @P1572 , @P1573 , @P1574 , @P1575 , @P1576 , @P1577 ,
@P1578 , @P1579 , @P1580 , @P1581 , @P1582 , @P1583 , @P1584 , @P1585 , @P1586 , @P1587 , @P1588 , @P1589 , @P1590 , @P1591 , @P1592 , @P1593 , @P1594 ,
@P1595 , @P1596 , @P1597 , @P1598 , @P1599 , @P1600 , @P1601 , @P1602 , @P1603 , @P1604 , @P1605 , @P1606 , @P1607 , @P1608 , @P1609 , @P1610 , @P1611 ,
@P1612 , @P1613 , @P1614 , @P1615 , @P1616 , @P1617 , @P1618 , @P1619 , @P1620 , @P1621 , @P1622 , @P1623 , @P1624 , @P1625 , @P1626 , @P1627 , @P1628 ,
@P1629 , @P1630 , @P1631 , @P1632 , @P1633 , @P1634 , @P1635 , @P1636 , @P1637 , @P1638 , @P1639 , @P1640 , @P1641 , @P1642 , @P1643 , @P1644 , @P1645 ,
@P1646 , @P1647 , @P1648 , @P1649 , @P1650 , @P1651 , @P1652 , @P1653 , @P1654 , @P1655 , @P1656 , @P1657 , @P1658 , @P1659 , @P1660 , @P1661 , @P1662 ,
@P1663 , @P1664 , @P1665 , @P1666 , @P1667 , @P1668 , @P1669 , @P1670 , @P1671 , @P1672 , @P1673 , @P1674 , @P1675 , @P1676 , @P1677 , @P1678 , @P1679 ,
@P1680 , @P1681 , @P1682 , @P1683 , @P1684 , @P1685 , @P1686 , @P1687 , @P1688 , @P1689 , @P1690 , @P1691 , @P1692 , @P1693 , @P1694 , @P1695 , @P1696 ,
@P1697 , @P1698 , @P1699 , @P1700 , @P1701 , @P1702 , @P1703 , @P1704 , @P1705 , @P1706 , @P1707 , @P1708 , @P1709 , @P1710 , @P1711 , @P1712 , @P1713 ,
@P1714 , @P1715 , @P1716 , @P1717 , @P1718 , @P1719 , @P1720 , @P1721 , @P1722 , @P1723 , @P1724 , @P1725 , @P1726 , @P1727 , @P1728 , @P1729 , @P1730 ,
@P1731 , @P1732 , @P1733 , @P1734 , @P1735 , @P1736 , @P1737 , @P1738 , @P1739 , @P1740 , @P1741 , @P1742 , @P1743 , @P1744 , @P1745 , @P1746 , @P1747 ,
@P1748 , @P1749 , @P1750 , @P1751 , @P1752 , @P1753 , @P1754 , @P1755 , @P1756 , @P1757 , @P1758 , @P1759 , @P1760 , @P1761 , @P1762 , @P1763 , @P1764 ,
@P1765 , @P1766 , @P1767 , @P1768 , @P1769 , @P1770 , @P1771 , @P1772 , @P1773 , @P1774 , @P1775 , @P1776 , @P1777 , @P1778 , @P1779 , @P1780 , @P1781 ,
@P1782 , @P1783 , @P1784 , @P1785 , @P1786 , @P1787 , @P1788 , @P1789 , @P1790 , @P1791 , @P1792 , @P1793 , @P1794 , @P1795 , @P1796 , @P1797 , @P1798 ,
@P1799 , @P1800 , @P1801 , @P1802 , @P1803 , @P1804 , @P1805 , @P1806 , @P1807 , @P1808 , @P1809 , @P1810 , @P1811 , @P1812 , @P1813 , @P1814 , @P1815 ,
@P1816 , @P1817 , @P1818 , @P1819 , @P1820 , @P1821 , @P1822 , @P1823 , @P1824 , @P1825 , @P1826 , @P1827 , @P1828 , @P1829 , @P1830 , @P1831 , @P1832 ,
@P1833 , @P1834 , @P1835 , @P1836 , @P1837 , @P1838 , @P1839 , @P1840 , @P1841 , @P1842 , @P1843 , @P1844 , @P1845 , @P1846 , @P1847 , @P1848 , @P1849 ,
@P1850 , @P1851 , @P1852 , @P1853 , @P1854 , @P1855 , @P1856 , @P1857 , @P1858 , @P1859 , @P1860 , @P1861 , @P1862 , @P1863 , @P1864 , @P1865 , @P1866 ,
@P1867 , @P1868 , @P1869 , @P1870 , @P1871 , @P1872 , @P1873 , @P1874 , @P1875 , @P1876 , @P1877 , @P1878 , @P1879 , @P1880 , @P1881 , @P1882 , @P1883 ,
@P1884 , @P1885 , @P1886 , @P1887 , @P1888 , @P1889 , @P1890 , @P1891 , @P1892 , @P1893 , @P1894 , @P1895 , @P1896 , @P1897 , @P1898 , @P1899 , @P1900 ,
@P1901 , @P1902 , @P1903 , @P1904 , @P1905 , @P1906 , @P1907 , @P1908 , @P1909 , @P1910 , @P1911 , @P1912 , @P1913 , @P1914 , @P1915 , @P1916 , @P1917 ,
@P1918 , @P1919 , @P1920 , @P1921 , @P1922 , @P1923 , @P1924 , @P1925 , @P1926 , @P1927 , @P1928 , @P1929 , @P1930 , @P1931 , @P1932 , @P1933 , @P1934 ,
@P1935 , @P1936 , @P1937 , @P1938 , @P1939 , @P1940 , @P1941 , @P1942 , @P1943 , @P1944 , @P1945 , @P1946 , @P1947 , @P1948 , @P1949 , @P1950 , @P1951 ,
@P1952 , @P1953 , @P1954 , @P1955 , @P1956 , @P1957 , @P1958 , @P1959 , @P1960 , @P1961 , @P1962 , @P1963 , @P1964 , @P1965 , @P1966 , @P1967 , @P1968 ,
@P1969 , @P1970 , @P1971 , @P1972 , @P1973 , @P1974 , @P1975 , @P1976 , @P1977 , @P1978 , @P1979 , @P1980 , @P1981 , @P1982 , @P1983 , @P1984 , @P1985 ,
@P1986 , @P1987 , @P1988 , @P1989 , @P1990 , @P1991 , @P1992 , @P1993 , @P1994 , @P1995 , @P1996 , @P1997 , @P1998 , @P1999)) 163156, 166995, 157622, 162716, 165906, 153699, 170586, 156777, 167732, 169158, 162779, 153042, 165462, 162120, 153483, 152142, 167606, 152161, 170852,
157600, 159397, 151884, 169173, 169213, 170270, 165818, 167449, 159242, 152713, 153496, 155935, 162480, 162088, 152991, 155108, 168655, 155086, 152436,
153005, 153724, 155263, 168558, 166641, 155447, 151848, 161776, 153173, 168222, 170687, 167709, 155102, 162740, 167843, 169104, 166021, 155247, 156785,
162735, 161755, 155162, 152705, 153152, 169165, 168934, 162128, 168264, 155255, 163237, 153505, 163223, 168733, 153716, 169072, 165449, 162857, 162503,
171521, 165297, 160246, 160214, 153021, 169679, 167045, 155277, 165446, 159435, 155094, 157601, 151718, 165435, 168367, 157463, 159234, 151739, 151868,
164255, 169906, 156533, 152177, 165580, 168542, 155154, 152583, 167832, 171141, 162483, 171116, 156794, 168230, 163300, 169152, 168432, 159280, 157500,
161738, 165171, 168440, 163231, 160507, 163599, 168762, 163253, 160530, 159250, 163446, 166009, 162080, 168027, 171132, 153154, 171291, 160198, 167028,
165465, 168535, 170937, 162467, 165174, 160203, 170676, 159694, 162093, 159219, 151892, 163591, 157617, 152272, 169795, 155284, 155293, 169187, 168266,
152878, 165684, 151852, 163245, 168771, 166147, 165454, 166979, 160294, 168746, 157592, 152997, 170654, 152920, 167740, 171056, 161731, 153736, 159275,
155131, 152463, 171123, 156541, 152860, 152145, 152578, 155139, 162743, 167019, 168841, 151840, 163226, 157616, 155944, 160179, 165575, 169197, 152444,
166658, 163264, 161747, 163283, 152134, 159258, 170431, 168322, 155930, 164825, 155075, 163576, 159864, 163278, 167003, 156786, 155123, 159227, 168256,
170823, 166649, 166987, 169730, 169181, 153470, 155269, 171283, 162491, 162101, 165328, 171184, 153614, 155936, 165427, 169685, 163807, 157484, 165679,
152870, 151860, 152903, 152886, 169029, 168550, 169087, 170838, 155262, 162625, 163270, 159243, 153041, 166996, 167619, 156778, 152150, 171299, 164406,
169917, 159237, 153518, 163238, 153482, 157606, 155928, 152445, 169174, 168843, 167726, 152992, 155252, 153723, 170931, 151881, 165463, 167708, 153172,
163232, 152817, 152854, 153033, 161792, 163299, 153351, 168263, 170432, 169216, 162500, 156759, 151875, 157587, 165343, 169096, 171073, 155101, 159708,
168654, 169166, 163441, 162734, 162502, 152437, 153031, 169810, 163275, 155444, 162635, 162858, 157819, 152952, 169103, 162482, 155093, 169907, 157468,
166030, 167017, 151867, 166611, 171121, 159288, 165473, 165568, 162127, 166144, 171058, 160213, 166765, 155155, 163615, 152005, 163261, 157726, 152703,
153499, 153600, 153702, 163593, 160515, 152469, 168763, 168439, 155107, 166010, 157501, 164414, 160506, 157088, 157718, 157595, 151889, 153024, 153491,
155274, 163254, 171293, 169010, 153691, 157317, 152452, 169915, 167038, 169676, 169794, 162094, 155078, 171255, 168545, 151851, 156538, 171294, 169208,
165179, 170268, 157477, 169927, 163286, 169188, 163267, 160197, 152859, 153752, 152460, 153735, 162102, 169904, 160182, 152487, 153180, 163596, 159427,
152919, 155134, 153694, 171129, 163246, 162475, 167493, 156997, 153474, 170125, 170677, 167025, 155285, 151723, 160204, 155290, 171189, 152875, 168850,
165481, 171126, 155941, 168255, 152476, 167022, 167466, 159230, 155126, 167609, 169916, 168321, 151878, 162751, 162138, 152851, 167743, 159259, 151897,
163588, 155929, 162648, 162501, 165319, 153622, 168935, 155266, 163449, 168730, 168838, 166148, 152158, 153157, 165824, 161927, 159265, 165695, 159240,
165300, 165344, 155152, 153613, 152998, 152143, 166022, 151845, 165698, 168776, 161736, 157485, 171286, 165678, 162490, 152883, 166648, 167004, 152904,
169289, 167600, 166136, 165346, 168271, 171071, 165470, 163294, 162717, 165441, 168896, 167735, 157607, 152869, 165327, 165895, 163225, 160312, 152185,
165572, 151859, 169182, 165308, 162375, 159442, 152140, 169175, 165486, 157700, 153502, 167599, 169030, 170947, 157586, 151882, 167447, 162090, 163310,
160582, 152004, 167734, 168731, 168544, 163247, 155916, 159281, 156756, 155096, 169912, 152888, 153726, 162721, 155933, 152453, 160264, 166215, 159256,
165330, 152853, 155110, 168653, 166019, 153485, 159236, 169095, 168228, 170942, 169211, 169160, 167461, 167711, 166000, 153175, 171158, 168760, 166769,
152442, 168936, 163592, 152151, 153003, 152951, 152896, 170429, 170433, 166168, 162197, 151870, 168220, 155445, 166997, 170272, 155160, 157708, 159278,
162505, 152814, 171139, 167604, 167665, 170934, 160509, 153748, 167721, 153599, 153701, 165348, 163239, 171065, 162494, 162367, 155080, 159696, 159222,
170126, 168178, 156783, 153498, 152711, 153709, 169923, 163326, 169167, 163288, 162718, 162126, 168744, 163444, 151720, 165582, 163258, 160224, 168143,
157502, 162485, 159154, 151725, 162655, 162082, 155279, 157603, 156539, 171057, 163302, 153490, 156764, 160205, 157465, 152214, 157594, 165444, 165897,
151997, 164412, 155925, 152172, 153183, 170674, 161744, 157729, 171036, 163285, 163578, 163597, 169793, 160296, 167005, 170441, 163272, 169090, 160315,
151728, 156546, 153693, 166007, 156791, 161959, 165452, 171134, 152251, 156992, 170035, 171285, 151749, 153598, 169189, 162469, 156033, 164549, 162474,
163437, 155942, 155133, 170150, 155286, 167742, 165322, 155137, 165690, 157478, 171195, 169889, 153718, 169098, 162095, 165577, 153604, 166981, 153761,
159420, 155077, 161745, 170458, 170825, 152914, 162391, 169704, 166989, 157620, 151846, 155271, 157507, 168272, 155125, 160188, 162085, 151871, 151877,
166206, 152475, 169403, 157604, 152132, 166643, 159229, 169183, 153472, 168258, 152905, 160177, 153612, 153156, 162103, 157489, 155085, 165299, 155442,
157628, 163293, 165034, 165478, 161753, 152435, 153501, 163589, 152872, 169801, 152159, 152588, 169067, 169195, 169106, 170962, 170952, 162498, 165180,
168777, 152995, 152880, 151854, 166651, 170134, 171107, 165471, 166137, 168029, 165307, 155104, 156775, 165345, 155934, 170434, 169176, 152856, 165905,
171068, 169274, 163447, 168437, 162504, 156763, 157699, 157621, 153503, 166653, 163248, 153738, 152148, 161737, 165461, 155095, 168761, 166020, 167598,
160524, 151861, 163033, 165424, 169151, 162087, 162633, 163151, 168445, 169496, 162372, 153725, 170579, 162719, 165432, 168647, 162736, 170943, 157589,
151887, 166998, 153174, 169157, 155260, 167710, 170573, 156536, 157707, 168217, 161750, 170269, 153730, 171295, 159241, 152283, 165913, 169902, 170430,
155109, 151869, 168745, 162125, 167460, 168177, 152893, 155161, 165447, 167720, 155135, 166016, 170262, 171288, 152443, 168234, 165440, 159279, 157716,
171142, 171115, 163240, 169913, 162495, 160535, 159221, 152164, 170422, 165809, 171513, 162737, 162484, 157602, 160540, 167713, 155254, 157462, 157457,
163595, 160417, 163439, 153712, 168652, 153745, 155153, 161920, 165569, 169168, 155276, 162726, 156784, 169214, 152701, 160206, 153704, 159239, 157454,
152190, 169905, 163301, 152848, 163280, 165685, 162477, 152877, 171035, 169789, 163367, 152183, 167737, 151853, 153717, 166197, 151895, 167006, 163256,
160314, 168340, 159437, 157613, 169925, 171187, 153696, 171131, 170675, 164824, 152906, 170123, 163277, 152175, 169089, 156792, 165177, 152458, 153090,
157618, 165310, 155088, 169184, 170955, 171124, 169190, 155142, 164442, 151742, 155128, 168146, 156547, 152198, 166008, 160222, 159232, 165433, 155292,
153603, 166982, 169084, 155939, 153762, 155287, 163296, 169097, 162096, 167020, 152156, 157479, 168845, 165574, 168454, 152133, 155150, 166642, 160187,
153754, 160180, 155268, 163263, 159689, 169198, 153611, 162373, 155443, 151843, 165468, 165479, 163586, 170822, 169146, 157487, 168257, 169105, 159286,
153484, 168937, 157756, 167842, 151872, 170578, 165693, 159271, 166138, 171027, 159257, 153011, 160566, 166205, 152141, 166650, 168774, 152921, 166209,
169800, 160195, 168836, 162117, 155103, 168323, 170985, 169686, 165338, 168269, 153333, 156776, 162492, 163269, 152871, 156758, 163334, 152898, 152885,
166035, 162084, 155120, 151864, 163353, 157596, 166017, 162723, 162861, 165476, 167024, 163233, 155259, 152149, 171304, 162636, 159224, 155090, 156766,
152138, 171128, 169169, 169100, 152855, 166571, 153479, 153737, 159238, 167602, 164405, 159246, 157727, 165807, 167453, 168444, 167463, 155931, 162302,
163274, 153783, 170826, 162487, 169108, 171067, 163304, 157706, 162124, 167597, 153729, 152993, 160210, 165431, 169177, 155923, 164251, 161932, 152154,
152010, 152451, 163249, 168233, 162507, 162365, 155143, 153487, 166013, 157458, 159254, 155136, 163594, 167723, 169868, 156789, 157744, 166645, 153177,
153728, 169154, 171287, 170940, 169194, 152173, 165439, 157089, 155918, 168436, 155273, 165293, 152930, 165899, 166028, 163279, 153607, 162468, 152908,
152847, 171185, 155158, 165584, 153597, 170263, 165484, 168844, 153191, 153046, 152702, 171403, 156781, 152189, 170932, 153703, 168938, 157496, 165189,
163610, 155288, 164413, 171253, 166984, 157467, 168141, 162471, 163580, 171038, 151896, 155289, 159249, 160519, 168766, 168531, 163266, 153596, 153695,
166991, 152180, 153711, 165309, 167736, 156773, 171117, 168270, 156031, 152916, 161742, 169753, 151722, 157504, 151743, 171044, 152432, 152157, 153690,
168828, 159231, 170950, 162730, 155087, 169083, 163350, 171135, 167484, 165688, 163241, 152866, 163295, 163435, 155940, 162097, 153602, 155151, 155098,
155265, 153632, 165450, 164094, 160183, 152864, 165349, 157480, 165902, 152130, 153753, 152899, 167610, 163587, 156537, 153004, 160215, 152874, 168260,
155264, 169051, 160186, 162629, 159247, 165459, 166999, 163230, 162476, 151844, 157626, 166778, 169191, 162105, 153610, 159430, 165894, 157488, 170566,
162116, 161924, 152882, 152459, 166664, 168837, 171279, 151856, 168775, 156757, 160194, 153508, 163289, 159216, 152448, 165301, 153158, 165469, 155112,
168175, 169161, 169092, 161735, 165442, 152897, 165316, 171052, 152994, 164268, 163445, 152247, 162631, 153027, 169681, 162862, 156765, 169400, 166018,
159223, 157473, 152850, 169170, 157733, 169107, 163303, 155089, 152887, 167844, 157697, 165674, 162486, 167605, 161748, 155145, 153740, 169025, 155932,
162089, 166131, 167452, 171029, 170688, 160389, 169159, 155448, 170827, 169178, 162106, 166644, 169911, 170448, 152162, 162639, 167000, 157472, 153151,
168333, 167021, 169212, 160529, 155130, 155258, 165817, 156534, 153478, 164826, 168759, 152895, 171125, 157610, 162123, 168541, 153732, 167722, 152433,
167118, 155079, 170137, 170935, 162506, 155278, 157591, 152456, 167462, 171140, 162728, 163250, 156790, 168236, 168743, 166054, 167865, 159255, 153727,
161931, 170264, 160537, 153190, 157714, 152473, 171290, 157464, 157459, 155917, 171133, 163242, 168830, 169459, 159233, 169081, 152261, 168650, 163287,
162479, 153486, 169033, 155281, 163257, 170815, 151719, 165438, 157599, 153618, 167955, 168317, 167529, 165445, 157456, 165347, 160510, 162470, 167623,
156569, 171448, 163809, 159688, 153698, 165571, 171303, 157497, 168427, 170791, 155924, 155159, 162081, 168215, 165907, 166025, 163234, 163271, 170121,
168216, 163575, 161743, 153153, 151893, 152879, 153020, 157730, 165453, 170575, 159269, 156787, 155937, 160327, 151855, 155140, 170953, 169900, 153719,
171118, 156774, 159226, 171043, 168829, 168767, 166049, 152915, 168026, 160316, 155122, 162704, 165175, 163434, 168267, 156542, 162731, 166568, 151727,
152865, 152863, 152269, 165350, 165332, 170428, 153002, 169086, 166006, 170824, 167746, 153222, 168259, 162744, 155097, 167739, 151736, 159276, 166041,
152131, 168536, 153601, 163808, 159284, 171196, 162652, 152873, 166610, 163229, 152699, 153148, 168834, 160216, 155440, 153017, 155441, 165312, 169806,
162098, 156545, 161788, 165691, 153009, 155111, 164093, 168549, 168325, 152900, 159215, 167008, 159093, 170580, 165458, 163282, 169192, 161732, 153609,
162086, 155270, 155261, 161964, 156760, 167081, 163453, 162644, 155082, 165820, 169196, 171051, 170924, 155945, 152139, 153756, 160193, 165304, 169099,
162371, 171282, 165683, 168772, 165466, 166652, 171110, 169091, 169162, 153393, 167837, 159248, 167596, 163290, 153507, 156768, 171306, 153007, 165295,
162634, 157611, 165429, 152147, 166993, 152457, 159244, 165035, 155092, 152144, 166569, 171040, 153481, 152857, 157498, 156535, 170930, 171069, 168932,
168540, 162658, 163276, 162859, 165342, 171298, 162513, 155275, 162478, 167455, 159684, 168262, 163251, 159701, 155257, 155106, 166023, 153731, 151874,
160236, 152700, 169682, 155129, 165317, 169215, 157624, 167611, 163142, 168442, 155267, 160189, 168336, 160013, 153714, 155253, 163243, 171191, 155920,
166141, 152707, 156779, 165448, 161757, 151866, 152892, 153468, 164822, 152931, 164424, 157717, 167018, 155156, 163448, 168434, 162481, 152163, 168764,
170816, 167457, 161749, 163262, 162738, 157461, 160319, 159252, 165437, 165570, 163235, 170576, 156770, 153594, 157598, 155921, 167945, 171289, 165474,
171122, 169163, 153494, 152203, 163432, 162509, 168320, 169034, 151886, 153023, 167725, 153697, 164554, 153179, 155144, 171061, 163298, 165464, 152849,
165587, 152211, 170265, 160201, 159438, 163268, 159218, 151850, 152876, 153734, 163259, 157704, 169179, 153605, 151894, 167026, 171186, 170122, 169207,
169085, 164553, 171130, 159667, 151842, 160320, 165694, 155282, 159251, 155141, 170698, 167001, 155121, 170437, 159225, 151724, 169082, 157460, 151729,
168025, 155291, 157614, 165573, 155100, 165821, 167717, 160181, 156771, 168368, 170425, 152449, 156680, 169102, 170939, 152932, 165434, 152488, 152155,
153473, 163574, 156761, 156543, 165686, 167738, 162732, 165912, 164831, 153616, 152999, 157469, 152136, 153744, 159285, 162099, 165311, 152901, 166977,
162661, 171281, 161926, 153621, 169134, 168548, 165904, 169155, 163281, 169877, 159260, 152852, 153171, 153755, 162510, 165326, 166647, 153722, 169094,
162091, 165303, 159441, 168268, 161733, 157608, 165457, 163228, 160311, 164906, 157474, 152479, 153010, 151858, 152884, 163222, 162714, 152858, 167015,
155256, 161934, 166133, 171119, 165467, 167838, 168781, 167456, 169171, 168835, 162374, 170646, 155083, 166985, 171520, 152868, 163585, 169185, 162489,
152446, 160200, 165819, 170948, 163584, 160531, 156532, 162722, 162083, 171127, 152245, 152889, 153700, 155081, 157585, 152152, 167023, 162488, 162121,
165428, 167480, 167733, 166994, 168833, 153721, 153480, 165341, 151873, 155147, 171297, 163252, 160192, 170933, 159245, 155439, 151847, 168537, 168933,
168261, 152287, 155105, 162129, 153742, 153008, 153471, 165306, 162108, 160233, 157735, 153713, 163147, 166056, 167454, 168441, 168221, 168559, 162508,
156767, 167831, 163244, 165190, 160497, 152137, 170679, 160225, 151865, 165298, 155919, 155446, 164262, 153750, 152462, 168366, 152731, 168656, 159253,
156793, 169193, 169210, 168433, 156780, 164823, 169153, 160555, 151791, 157499, 159235, 169909, 166393, 163236, 153178, 163297, 157466, 166983, 156769,
152815, 153239, 166436, 169147, 152213, 166566, 159424, 162212, 151883, 164555, 155157, 155922, 156788, 160512, 157593, 153035, 169164, 162746, 157720,
159220, 153489, 165436, 167724, 159432, 166012, 159217, 163598, 153513, 157703, 163260, 168534, 168265, 155283, 165909, 162733, 165181, 153155, 153733,
152252, 161741, 152867, 159267, 161832, 163040, 152179, 168778, 155138, 165581, 163577, 153608, 151721, 152598, 168765, 152153, 171292, 168840, 161816,
169209, 160202, 155099, 169890, 156540, 164409, 160295, 165173, 160505, 170699, 156762, 162473, 167459, 165451, 157508, 167741, 169101, 169180, 170127,
171045, 152294, 163638, 160184, 155132, 159433, 155272, 151839, 152917, 167002, 171064, 170938, 155943, 163284, 167065, 161925, 165483, 152589, 153000,
153615, 161746, 166978, 162650, 157483, 166574, 155076, 171112, 151876, 153170, 163273, 170951, 164552, 162511, 162100, 167839, 169172, 160321, 169156,
157490, 153705, 165472, 159228, 155280, 155124, 159425, 155084, 162626, 157475, 151857, 169088, 157711, 171284, 162092, 163292, 163590, 151746, 163227,
163265, 161933, 159282, 155251, 152478, 171120, 153504, 152160, 167016, 152129, 152902, 169093, 152244, 169186, 159261, 162113, 166986, 155146, 160199,
157625, 162937, 168664, 168174, 166646
SELECT @p1
December 23, 2011 at 12:14 pm
ok, it's time to play...
NAME...THAT...VENDOR!
Lowell
December 23, 2011 at 12:16 pm
I don't know that vendor, but I'd be curious as to know why this is running slow. This shouldn't be hard / long to run.
The compile time might be abysmal tho!
December 23, 2011 at 1:12 pm
Ninja's_RGR'us (12/23/2011)
I don't know that vendor, but I'd be curious as to know why this is running slow. This shouldn't be hard / long to run.The compile time might be abysmal tho!
Yeah, it slams the cpu for 10 seconds. They are getting mighty close to the 2100 paramter limit.
December 23, 2011 at 2:51 pm
Heh... gosh... I don't know why anyone would think that's bad code considering the "standard" that MS set when they wrote sp_execresultset for SQL Server 2000.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 23, 2011 at 4:17 pm
ben.rosato (12/23/2011)
Ninja's_RGR'us (12/23/2011)
I don't know that vendor, but I'd be curious as to know why this is running slow. This shouldn't be hard / long to run.The compile time might be abysmal tho!
Yeah, it slams the cpu for 10 seconds. They are getting mighty close to the 2100 paramter limit.
What's the compile time?
December 25, 2011 at 5:26 pm
Lowell (12/23/2011)
ok, it's time to play...NAME...THAT...VENDOR!
Heh... Let's start with a category... ORM? Ok... Hibernate? NHibernate? LINQ? Any other suggestions?
--Jeff Moden
Change is inevitable... Change for the better is not.
December 27, 2011 at 12:46 pm
Looks like CoreCard to me...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 28, 2011 at 4:14 am
Ninja's_RGR'us (12/23/2011)
ben.rosato (12/23/2011)
Ninja's_RGR'us (12/23/2011)
I don't know that vendor, but I'd be curious as to know why this is running slow. This shouldn't be hard / long to run.The compile time might be abysmal tho!
Yeah, it slams the cpu for 10 seconds. They are getting mighty close to the 2100 paramter limit.
What's the compile time?
Compile time is about 9.5 seconds.
December 28, 2011 at 6:21 am
ben.rosato (12/28/2011)
Ninja's_RGR'us (12/23/2011)
ben.rosato (12/23/2011)
Ninja's_RGR'us (12/23/2011)
I don't know that vendor, but I'd be curious as to know why this is running slow. This shouldn't be hard / long to run.The compile time might be abysmal tho!
Yeah, it slams the cpu for 10 seconds. They are getting mighty close to the 2100 paramter limit.
What's the compile time?
Compile time is about 9.5 seconds.
So 95%+ of the query is spent on compiling?!?!
Nothing I can suggest aside from the very obvious, kill the vendor and find a new one.
December 28, 2011 at 7:21 am
If I'm reading it correctly, it's pretty much just a "Where in (values)" statement with as close to unlimited number of allowed values as they felt they could get. Intead of just a delimited list, or a TVF (which may or may not be an option if they have to maintain backwards compatibility beyond SQL 2008).
Probably just some dev who felt that optional parameters were better than a list splitter. If he didn't know the high-performance methods of list splitting, and really needed to accept lists of 1000 or more values, then it almost makes sense. It would definitely perform better, once compiled, than a loop to split a 1000-value delimited string, including conversion from string values to bigint values and all that. If it's something that can compile once and keep a plan in the cache, then it might even be overall better than a delimited list version. Assuming, again, inefficient list parsing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 28, 2011 at 7:29 am
GSquared (12/28/2011)
If I'm reading it correctly, it's pretty much just a "Where in (values)" statement with as close to unlimited number of allowed values as they felt they could get. Intead of just a delimited list, or a TVF (which may or may not be an option if they have to maintain backwards compatibility beyond SQL 2008).Probably just some dev who felt that optional parameters were better than a list splitter. If he didn't know the high-performance methods of list splitting, and really needed to accept lists of 1000 or more values, then it almost makes sense. It would definitely perform better, once compiled, than a loop to split a 1000-value delimited string, including conversion from string values to bigint values and all that. If it's something that can compile once and keep a plan in the cache, then it might even be overall better than a delimited list version. Assuming, again, inefficient list parsing.
It's not fault of dev. It’s a tool generated query.
December 28, 2011 at 7:30 am
It seems to me that the need to send 2000+ parameters for an "IN" clause is the symptom of a poor design.
December 28, 2011 at 7:34 am
ben.rosato (12/28/2011)
It seems to me that the need to send 2000+ parameters for an "IN" clause is the symptom of a poor design.
Poor design of database, probably NO. It’s a bad design of 3rd party tool’s query / database engine.
December 28, 2011 at 7:38 am
Dev (12/28/2011)
GSquared (12/28/2011)
If I'm reading it correctly, it's pretty much just a "Where in (values)" statement with as close to unlimited number of allowed values as they felt they could get. Intead of just a delimited list, or a TVF (which may or may not be an option if they have to maintain backwards compatibility beyond SQL 2008).Probably just some dev who felt that optional parameters were better than a list splitter. If he didn't know the high-performance methods of list splitting, and really needed to accept lists of 1000 or more values, then it almost makes sense. It would definitely perform better, once compiled, than a loop to split a 1000-value delimited string, including conversion from string values to bigint values and all that. If it's something that can compile once and keep a plan in the cache, then it might even be overall better than a delimited list version. Assuming, again, inefficient list parsing.
It's not fault of dev. It’s a tool generated query.
The tool was probably written by a dev somewhere along the way.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply