database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
ㆍMS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MS-SQL Q&A 5417 게시물 읽기
No. 5417
where의 조건이 많을 때 오류
작성자
황운호(whsunbi)
작성일
2009-10-16 18:43
조회수
7,770

안녕하세요.
고수 분들의 도움을 청합니다.

쿼리를 그대로 붙이면 다음과 같습니다.
거의 4000개의 조건인데요.. (무식한가요..;;)

저렇게 돌리면 오류를 반환합니다.
 --> 오류가 안나면서 성능이 좋게 할 수 있는 방법이 있으면 부탁드립니다.

“쿼리 프로세서에서 내부 리소스가 부족하므로 쿼리 계획을 생성할 수 없습니다. 이러한 이벤트는 매우 드물게 발생하며 쿼리가 너무 복잡하거나 너무 많은 테이블 또는 파티션을 참조하는 경우에만 발생합니다. 쿼리를 단순하게 만드십시오. 이 메시지가 오류로 인해 표시되었다고 판단되면 고객 지원 서비스에 자세한 내용을 문의하십시오.”



>> QUERY

 SELECT * 
 FROM
 CONTENTS_VIEW  V
 WHERE 
                V.idx IN ( 7973, 7974, 7975, 7976, 7977, 7821, 7822, 7823, 7824, 7825, 7781, 7812, 7813, 7814, 7815, 7895, 7894, 7864, 7865, 7866, 7853, 7856, 7871, 7851, 7852, 7857, 7854, 7860, 7862, 7872, 7859, 7858, 7863, 7861, 7868, 7870, 7873, 7867, 7869, 7881, 7882, 7875, 7876, 7874, 7877, 7886, 7888, 7884, 7887, 7885, 7878, 7879, 7880, 7891, 7893, 7889, 7892, 7890, 7850, 7847, 7849, 7848, 7835, 7837, 7836, 7833, 7832, 7834, 7839, 7841, 7843, 7842, 7840, 7838, 7826, 7828, 7827, 7819, 7818, 7820, 7829, 7830, 7831, 7846, 7844, 7845, 7816, 7787, 7788, 7789, 7790, 7782, 7786, 7785, 7795, 7809, 7810, 7811, 7801, 7802, 7806, 7808, 7807, 7803, 7804, 7805, 7791, 7792, 7793, 7794, 7796, 7797, 7798, 7799, 7800, 7780, 7778, 7779, 7777, 7768, 7773, 7770, 7769, 7772, 7775, 7776, 7774, 7766, 7771, 7898, 7896, 7897, 7899, 7901, 7900, 7922, 7921, 7920, 7919, 7927, 7925, 7924, 7930, 7931, 7926, 7923, 7929, 7928, 7932, 7905, 7904, 7913, 7910, 7914, 7902, 7916, 7908, 7912, 7911, 7909, 7903, 7906, 7907, 7915, 7918, 7917, 7935, 7938, 7936, 7937, 7939, 7933, 7934, 9857, 9858, 9859, 9860, 9856, 9855, 9854, 9861, 9862, 9868, 9879, 9880, 9881, 9882, 9869, 9875, 9873, 9874, 9871, 9872, 9870, 9876, 9878, 9877, 9883, 9884, 9886, 9885, 9887, 9888, 9889, 9863, 9864, 9866, 9865, 7951, 7952, 7954, 7950, 7971, 7970, 7968, 7969, 7972, 7966, 7962, 7963, 7967, 7965, 7964, 7941, 7942, 7945, 7944, 7946, 7947, 7948, 7943, 7949, 7953, 7940, 7958, 7955, 7959, 7960, 7957, 7986, 7978, 7979, 7980, 7981, 7982, 7985, 7983, 7984, 7987, 7988, 8004, 8003, 8005, 8006, 8002, 8001, 7991, 7989, 7990, 8000, 7999, 7996, 7995, 7998, 7997, 7994, 7992, 7993, 8008, 8009, 8010, 8024, 8026, 8027, 8025, 8028, 8067, 8069, 8068, 8070, 8017, 8019, 8020, 8021, 8022, 8023, 8037, 8038, 8036, 8039, 8040, 8041, 8042, 8031, 8029, 8032, 8033, 8030, 8034, 8035, 8049, 8052, 8053, 8054, 8050, 8062, 8051, 8044, 8043, 8045, 8046, 8047, 8048, 8011, 8012, 8013, 8014, 8016, 8063, 8064, 8065, 8066, 8128, 8018, 8127, 8092, 8090, 8091, 8093, 8094, 8095, 8096, 8085, 8083, 8086, 8087, 8088, 8084, 8089, 8078, 8076, 8079, 8080, 8081, 8077, 8082, 8073, 8071, 8074, 8072, 8075, 8102, 8104, 8105, 8106, 8103, 8107, 8097, 8099, 8100, 8098, 8101, 8129, 8125, 8123, 8124, 8126, 8007, 8117, 8115, 8118, 8120, 8121, 8116, 8122, 8110, 8108, 8111, 8112, 8113, 8109, 8114, 8137, 8130, 8139, 8135, 8138, 8132, 8136, 8133, 8131, 8134, 8140, 8141, 8164, 8170, 8169, 8168, 8167, 8166, 8165, 8163, 8147, 8148, 8153, 8154, 8155, 8152, 8150, 8151, 8149, 8146, 8142, 8143, 8159, 8160, 8161, 8162, 8158, 8156, 8157, 8171, 8187, 8191, 8192, 8189, 8190, 8188, 8218, 8219, 8220, 8193, 8202, 8206, 8207, 8204, 8205, 8203, 8226, 8227, 8225, 8228, 8208, 8194, 8198, 8199, 8196, 8200, 8197, 8195, 8222, 8223, 8221, 8224, 8201, 8179, 8183, 8184, 8181, 8185, 8182, 8180, 8215, 8216, 8214, 8217, 8186, 8172, 8176, 8177, 8174, 8175, 8173, 8178, 8212, 8210, 8211, 8209, 8213, 8060, 8061, 8055, 8056, 8057, 8058, 8059, 8240, 8241, 8233, 8231, 8230, 8236, 8229, 8235, 8232, 8234, 8238, 8239, 8237, 8244, 8245, 8246, 8242, 8243, 8390, 8391, 8405, 8403, 8406, 8408, 8407, 8402, 8404, 8401, 8409, 8392, 8396, 8394, 8393, 8395, 8399, 8398, 8397, 8410, 8412, 8411, 8387, 8389, 8388, 8258, 8262, 8259, 8260, 8261, 8263, 8249, 8251, 8250, 8248, 8256, 8257, 8252, 8247, 8255, 8264, 8253, 8265, 8254, 8488, 8458, 8459, 8478, 8474, 8477, 8462, 8461, 8454, 8466, 8469, 8468, 8467, 8460, 8457, 8475, 8476, 8470, 8473, 8471, 8472, 8464, 8465, 8456, 8463, 8455, 8452, 8451, 8453, 8489, 8490, 8491, 8497, 8495, 8492, 8500, 8493, 8498, 8494, 8496, 8499, 8426, 8429, 8428, 8430, 8425, 8427, 8431, 8421, 8424, 8423, 8422, 8434, 8432, 8433, 8484, 8483, 8479, 8482, 8481, 8480, 8440, 8439, 8438, 8435, 8437, 8436, 8441, 8442, 8420, 8419, 8446, 8444, 8443, 8445, 8447, 8487, 8485, 8486, 8450, 8449, 8448, 8501, 8414, 8413, 8415, 8417, 8418, 8416, 8374, 8375, 8376, 8369, 8373, 8370, 8372, 8385, 8379, 8381, 8380, 8378, 8377, 8384, 8382, 8386, 8359, 8356, 8355, 8354, 8358, 8353, 8357, 8352, 8342, 8339, 8338, 8337, 8341, 8336, 8340, 8335, 8333, 8330, 8329, 8334, 8328, 8332, 8327, 8331, 8326, 8367, 8364, 8363, 8368, 8362, 8366, 8361, 8365, 8360, 8350, 8347, 8346, 8351, 8345, 8349, 8344, 8348, 8343, 8282, 8279, 8278, 8283, 8277, 8281, 8276, 8280, 8275, 8299, 8295, 8294, 8300, 8293, 8298, 8292, 8297, 8291, 8273, 8270, 8269, 8274, 8268, 8272, 8267, 8271, 8266, 8308, 8305, 8304, 8303, 8307, 8302, 8306, 8301, 8316, 8313, 8312, 8311, 8315, 8310, 8314, 8309, 8324, 8321, 8320, 8325, 8319, 8323, 8318, 8322, 8317, 8290, 8287, 8286, 8289, 8285, 8288, 8284, 8383, 8528, 8527, 8529, 8537, 8536, 8535, 8534, 8533, 8530, 8532, 8531, 8540, 8538, 8539, 8541, 8510, 8511, 8512, 8513, 8514, 8515, 8516, 8548, 8517, 8518, 8519, 8520, 8521, 8522, 8523, 8524, 8525, 8526, 8504, 8508, 8509, 8506, 8507, 8505, 8556, 8557, 8558, 8559, 8560, 8561, 8549, 8550, 8551, 8565, 8563, 8562, 8564, 8566, 8567, 8568, 8502, 8543, 8542, 8503, 8544, 8545, 8546, 8547, 8555, 8554, 8552, 8553, 8574, 8582, 8583, 8584, 8585, 8586, 8587, 8575, 8576, 8577, 8591, 8589, 8588, 8590, 8592, 8593, 8594, 8570, 8569, 8571, 8572, 8573, 8581, 8580, 8578, 8579, 8601, 8612, 8613, 8614, 8615, 8616, 8617, 8603, 8604, 8605, 8622, 8620, 8618, 8621, 8623, 8624, 8625, 8596, 8595, 8597, 8598, 8600, 8599, 8610, 8611, 8609, 8608, 8606, 8607, 8633, 8643, 8644, 8645, 8646, 8647, 8648, 8634, 8635, 8636, 8652, 8650, 8649, 8651, 8653, 8654, 8655, 8627, 8626, 8628, 8631, 8632, 8641, 8642, 8640, 8639, 8637, 8638, 8666, 8682, 8683, 8684, 8685, 8686, 8687, 8667, 8668, 8669, 8678, 8680, 8656, 8679, 8677, 8676, 8681, 8661, 8658, 8662, 8663, 8665, 8664, 8674, 8675, 8673, 8672, 8670, 8671, 9014, 9022, 9023, 9024, 9025, 9026, 9027, 9015, 9016, 9017, 9031, 9029, 9028, 9030, 9032, 9033, 9034, 9009, 9008, 9010, 9011, 9013, 9012, 9021, 9020, 9018, 9019, 9041, 9046, 9047, 9048, 9077, 9078, 9079, 9075, 9076, 9050, 9049, 9051, 9052, 9053, 9054, 9036, 9035, 9037, 9038, 9040, 9039, 9045, 9044, 9042, 9043, 9061, 9083, 9066, 9067, 9084, 9085, 9086, 9080, 9081, 9082, 9069, 9068, 9070, 9071, 9072, 9073, 9056, 9055, 9057, 9058, 9060, 9059, 9065, 9064, 9062, 9063, 9092, 9101, 9102, 9103, 9104, 9105, 9106, 9093, 9094, 9095, 9110, 9108, 9107, 9109, 9111, 9112, 9113, 9087, 9074, 9088, 9089, 9091, 9090, 9100, 9099, 9098, 9096, 9097, 9301, 9309, 9310, 9311, 9312, 9313, 9314, 9302, 9303, 9304, 9318, 9316, 9315, 9317, 9319, 9320, 9321, 9295, 9294, 9296, 9297, 9300, 9298, 9308, 9307, 9305, 9306, 9328, 9338, 9339, 9340, 9341, 9342, 9343, 9329, 9330, 9331, 9347, 9345, 9344, 9346, 9348, 9349, 9350, 9323, 9322, 9324, 9325, 9327, 9326, 9336, 9337, 9335, 9334, 9332, 9333, 9358, 9367, 9368, 9369, 9370, 9371, 9372, 9359, 9361, 9362, 9376, 9374, 9373, 9375, 9377, 9378, 9379, 9353, 9352, 9354, 9355, 9357, 9356, 9366, 9365, 9363, 9364, 9386, 9393, 9394, 9395, 9396, 9397, 9398, 9387, 9388, 9402, 9400, 9399, 9401, 9403, 9404, 9405, 9381, 9380, 9382, 9383, 9385, 9384, 9392, 9391, 9389, 9390, 9412, 9420, 9421, 9422, 9423, 9424, 9425, 9413, 9414, 9415, 9429, 9427, 9426, 9428, 9430, 9431, 9432, 9407, 9406, 9408, 9409, 9411, 9410, 9419, 9418, 9416, 9417, 9439, 9447, 9448, 9449, 9450, 9451, 9440, 9441, 9442, 9455, 9453, 9452, 9454, 9456, 9457, 9458, 9434, 9433, 9435, 9436, 9438, 9437, 9446, 9445, 9443, 9444, 9465, 9473, 9474, 9475, 9476, 9477, 9478, 9466, 9467, 9468, 9482, 9480, 9479, 9481, 9483, 9484, 9485, 9460, 9459, 9461, 9462, 9464, 9463, 9472, 9471, 9469, 9470, 9492, 9499, 9500, 9501, 9502, 9503, 9493, 9494, 9507, 9505, 9504, 9506, 9508, 9509, 9510, 9487, 9486, 9488, 9489, 9491, 9490, 9498, 9497, 9495, 9496, 9517, 9525, 9526, 9527, 9528, 9529, 9530, 9518, 9519, 9520, 9534, 9532, 9531, 9533, 9535, 9536, 9537, 9512, 9511, 9513, 9514, 9516, 9515, 9524, 9523, 9521, 9522, 9547, 9554, 9555, 9556, 9557, 9558, 9560, 9548, 9549, 9562, 9561, 9563, 9564, 9565, 9566, 9542, 9541, 9543, 9544, 9546, 9545, 9553, 9552, 9550, 9551, 9577, 9697, 9698, 9699, 9700, 9701, 9702, 9578, 9579, 9695, 9706, 9704, 9703, 9705, 9707, 9708, 9709, 9571, 9570, 9572, 9573, 9576, 9574, 9696, 9694, 9580, 9693, 9716, 9723, 9724, 9725, 9726, 9727, 9728, 9717, 9718, 9732, 9730, 9729, 9731, 9733, 9734, 9735, 9711, 9710, 9712, 9713, 9715, 9714, 9722, 9721, 9719, 9720, 9742, 9750, 9751, 9752, 9753, 9754, 9755, 9743, 9744, 9745, 9759, 9757, 9756, 9758, 9760, 9761, 9762, 9737, 9736, 9738, 9739, 9741, 9740, 9749, 9748, 9746, 9747, 9769, 9775, 9776, 9777, 9778, 9779, 9780, 9770, 9771, 9784, 9782, 9781, 9783, 9785, 9786, 9787, 9764, 9763, 9765, 9766, 9768, 9767, 9774, 9773, 9772, 9794, 9802, 9803, 9804, 9805, 9806, 9807, 9795, 9796, 9797, 9812, 9810, 9808, 9811, 9813, 9814, 9815, 9789, 9788, 9790, 9791, 9793, 9792, 9801, 9800, 9798, 9799, 9824, 9825, 9819, 9818, 9821, 9823, 9822, 9826, 9820, 9832, 9833, 9834, 9830, 9831, 9828, 9827, 9839, 9840, 9841, 9835, 9838, 9837, 9836, 9842, 9844, 9845, 9843, 9849, 9847, 9848, 9846, 9895, 9853, 9851, 9850, 9852, 9896, 9897, 9898, 9900, 9899, 9908, 9910, 9909, 9907, 9906, 9925, 9924, 9923, 9911, 9914, 9915, 9912, 9921, 9920, 9919, 9918, 9917, 9916, 9913, 9922, 9903, 9902, 9901, 9904, 9905, 9954, 9953, 9956, 9957, 9955, 9960, 9962, 9958, 9959, 9961, 9963, 9971, 9966, 9965, 9964, 9972, 9967, 9970, 9968, 9973, 9935, 9934, 9939, 9938, 9940, 9937, 9941, 9936, 9952, 9950, 9943, 9951, 9949, 9946, 9944, 9945, 9948, 9947, 9931, 9932, 9933, 9942, 9928, 9929, 9927, 9926, 9930, 9979, 9974, 9978, 9975, 9977, 9976, 9980, 9982, 9984, 9983, 9985, 9986, 9981, 9987, 9988, 9989, 9996, 9998, 9997, 10022, 10023, 10019, 10020, 10021, 10026, 10024, 10025, 9994, 9992, 9993, 9991, 9990, 10004, 10011, 10005, 10007, 10010, 10008, 10014, 10013, 10012, 10006, 10009, 10002, 10000, 9999, 10001, 10003, 10015, 10017, 10016, 10027, 10029, 10028, 10120, 10121, 10123, 10122, 10124, 10126, 10125, 10103, 10100, 10102, 10104, 10105, 10101, 10118, 10119, 10110, 10111, 10112, 10113, 10114, 10109, 10107, 10108, 10106, 10115, 10116, 10117, 10086, 10085, 10084, 10088, 10087, 10089, 10079, 10083, 10080, 10081, 10082, 10066, 10065, 10063, 10069, 10068, 10067, 10053, 10052, 10090, 10099, 10097, 10096, 10098, 10092, 10091, 10093, 10078, 10076, 10073, 10072, 10074, 10075, 10071, 10070, 10077, 10062, 10059, 10058, 10061, 10057, 10055, 10054, 10056, 10060, 10036, 10040, 10043, 10042, 10041, 10038, 10039, 10037, 10034, 10033, 10035, 10051, 10049, 10050, 10048, 10045, 10044, 10047, 10046, 10136, 10137, 10128, 10127, 10129, 10144, 10143, 10145, 10142, 10146, 10150, 10151, 10152, 10153, 10149, 10147, 10148, 10141, 10139, 10138, 10140, 10132, 10131, 10130, 10135, 10133, 10134, 10164, 10165, 10189, 10186, 10188, 10187, 10170, 10172, 10158, 10156, 10160, 10161, 10159, 10157, 10155, 10162, 10154, 10163, 10169, 10168, 10166, 10167, 10171, 10185, 10184, 10182, 10183, 10179, 10177, 10178, 10180, 10181, 10174, 10175, 10176, 10173, 10190, 10191, 10196, 10194, 10197, 10195, 10193, 10204, 10203, 10205, 10202, 10201, 10207, 10206, 10192, 10199, 10198, 10200, 10213, 10208, 10209, 10210, 10211, 10212, 10224, 10223, 10222, 10221, 10225, 10219, 10218, 10217, 10220, 10215, 10214, 10216, 10240, 10246, 10251, 10247, 10248, 10249, 10250, 10239, 10242, 10245, 10243, 10241, 10252, 10231, 10237, 10238, 10236, 10234, 10233, 10232, 10235, 10226, 10229, 10227, 10230, 10228, 10311, 10312, 10307, 10304, 10306, 10305, 10314, 10309, 10310, 10308, 10315, 10313, 10297, 10300, 10298, 10299, 10296, 10295, 10301, 10303, 10302, 10262, 10257, 10258, 10256, 10254, 10255, 10253, 10259, 10260, 10261, 10264, 10263, 10265, 10275, 10274, 10273, 10276, 10266, 10267, 10268, 10272, 10271, 10269, 10270, 10286, 10287, 10277, 10279, 10278, 10282, 10281, 10280, 10284, 10283, 10285, 10294, 10288, 10289, 10291, 10290, 10292, 10338, 10332, 10333, 10334, 10328, 10337, 10329, 10330, 10331, 10335, 10336, 10317, 10327, 10325, 10320, 10321, 10324, 10322, 10323, 10318, 10316, 10319, 10326, 10340, 10339, 10342, 10347, 10346, 10348, 10341, 10344, 10345, 10343, 10350, 10349, 10351, 10380, 10379, 10373, 10377, 10376, 10378, 10374, 10375, 10382, 10381, 10383, 10384, 10397, 10386, 10387, 10393, 10388, 10389, 10390, 10391, 10392, 10396, 10394, 10395, 10398, 10385, 10352, 10362, 10358, 10357, 10359, 10356, 10353, 10355, 10354, 10360, 10361, 10363, 10364, 10372, 10369, 10368, 10370, 10371, 10365, 10367, 10366, 10407, 10409, 10406, 10408, 10404, 10405, 10434, 10436, 10435, 10431, 10433, 10432, 10430, 10428, 10429, 10410, 10412, 10411, 10426, 10427, 10414, 10415, 10413, 10416, 10417, 10418, 10419, 10421, 10424, 10423, 10422, 10420, 10425, 10403, 10402, 10401, 10399, 10400, 10437, 10440, 10439, 10438, 10441, 10446, 10452, 10448, 10447, 10451, 10450, 10449, 10442, 10443, 10444, 10445, 10455, 10453, 10454, 10456, 10457, 10459, 10460, 10458, 10461, 10470, 10467, 10469, 10468, 10471, 10466, 10472, 10465, 10464, 10463, 10462, 10512, 10511, 10497, 10513, 10515, 10519, 10516, 10518, 10517, 10514, 10520, 10522, 10521, 10523, 10495, 10494, 10496, 10482, 10481, 10478, 10480, 10483, 10489, 10493, 10492, 10491, 10487, 10486, 10490, 10485, 10484, 10502, 10501, 10503, 10498, 10500, 10499, 10509, 10508, 10504, 10507, 10510, 10506, 10505, 10474, 10475, 10476, 10477, 10473, 10553, 10532, 10528, 10534, 10533, 10529, 10530, 10531, 10527, 10535, 10540, 10539, 10541, 10538, 10537, 10536, 10558, 10557, 10554, 10555, 10556, 10544, 10543, 10542, 10545, 10551, 10550, 10552, 10548, 10547, 10546, 10549, 10597, 10598, 10600, 10599, 10591, 10592, 10594, 10593, 10595, 10596, 10601, 10602, 10606, 10589, 10590, 10603, 10605, 10604, 10607, 10653, 10644, 10648, 10642, 10643, 10645, 10647, 10646, 10633, 10634, 10641, 10637, 10638, 10639, 10635, 10640, 10636, 10650, 10652, 10651, 10649, 10632, 10847, 10843, 10845, 10844, 10842, 10846, 10848, 10849, 10853, 10852, 10850, 10859, 10860, 10855, 10856, 10857, 10858, 10854, 10851, 10864, 10863, 10861, 10865, 10862, 10869, 10868, 10866, 10870, 10867, 10875, 10876, 10873, 10872, 10871, 10874, 10803, 10823, 10822, 10824, 10820, 10819, 10821, 10835, 10836, 10834, 10825, 10826, 10809, 10808, 10810, 10804, 10805, 10833, 10831, 10830, 10832, 10806, 10807, 10812, 10811, 10813, 10814, 10815, 10817, 10816, 10818, 10828, 10827, 10829, 10838, 10839, 10837, 10840, 10841, 10617, 10620, 10618, 10621, 10619, 10629, 10609, 10612, 10611, 10610, 10631, 10622, 10624, 10625, 10626, 10628, 10627, 10613, 10614, 10615, 10616, 10608, 10630, 10654, 10658, 10657, 10659, 10660, 10655, 10656, 10786, 10785, 10687, 10688, 10690, 10689, 10692, 10691, 10695, 10694, 10693, 10696, 10686, 10713, 10715, 10714, 10719, 10718, 10721, 10720, 10717, 10716, 10697, 10698, 10700, 10705, 10712, 10706, 10701, 10704, 10702, 10709, 10703, 10707, 10710, 10711, 10699, 10685, 10684, 10723, 10722, 10762, 10749, 10750, 10752, 10753, 10751, 10754, 10758, 10761, 10759, 10756, 10755, 10757, 10760, 10745, 10746, 10744, 10742, 10748, 10747, 10743, 10737, 10739, 10736, 10738, 10735, 10741, 10740, 10732, 10733, 10734, 10763, 10663, 10661, 10662, 10683, 10675, 10679, 10677, 10676, 10681, 10678, 10680, 10682, 10674, 10668, 10667, 10669, 10670, 10664, 10665, 10666, 10673, 10771, 10770, 10766, 10764, 10769, 10768, 10765, 10767, 10729, 10731, 10730, 10725, 10724, 10726, 10727, 10728, 10800, 10802, 10801, 10783, 10780, 10781, 10782, 10784, 10773, 10776, 10775, 10779, 10774, 10777, 10778, 10772, 10787, 10795, 10794, 10796, 10790, 10788, 10798, 10789, 10791, 10799, 10792, 10793, 10797, 10586, 10587, 10582, 10580, 10581, 10584, 10583, 10588, 10585, 10570, 10574, 10575, 10571, 10573, 10572, 10559, 10568, 10566, 10563, 10569, 10565, 10567, 10564, 10576, 10579, 10577, 10578, 10879, 10878, 10880, 10877, 10892, 10894, 10893, 10896, 10895, 10887, 10888, 10886, 10885, 10883, 10882, 10884, 10881, 10891, 10889, 10890, 10901, 10902, 10899, 10900, 10917, 10916, 10920, 10914, 10918, 10913, 10915, 10919, 10897, 10898, 10910, 10909, 10911, 10904, 10908, 10912, 10903, 10922, 10921, 10942, 10943, 10925, 10929, 10931, 10930, 10928, 10927, 10926, 10923, 10924, 10935, 10934, 10936, 10932, 10933, 10941, 10939, 10938, 10940, 10937, 10965, 10964, 10963, 11006, 11013, 11007, 11011, 11012, 11010, 11005, 11008, 11009, 10987, 10989, 10988, 10984, 10986, 10985, 10978, 10980, 10979, 10990, 10992, 10991, 10993, 10995, 10994, 10973, 10975, 10974, 10981, 10983, 10982, 10996, 10997, 10976, 10977, 10968, 10969, 10972, 10971, 10970, 10958, 10957, 10959, 10960, 10961, 10962, 10947, 10948, 10949, 10950, 10954, 10952, 10953, 10951, 10956, 10955, 10946, 10966, 10967, 11004, 10999, 11003, 11001, 11000, 10998, 11002, 11035, 11029, 11020, 11022, 11024, 11014, 11023, 11019, 11015, 11016, 11018, 11017, 11026, 11025, 11027, 11036, 11028, 11031, 11033, 11032, 11034, 11030, 11037, 11046, 11045, 11038, 11039, 11047, 11040, 11041, 11042, 11043, 11044, 11048, 11049, 11055, 11064, 11065, 11062, 11063, 11059, 11056, 11057, 11061, 11058, 11060, 11051, 11053, 11054, 11052, 11050, 11070, 11067, 11071, 11073, 11072, 11069, 11068, 11077, 11074, 11075, 11076, 11080, 11083, 11081, 11082, 11079, 11078, 11084, 11085, 11090, 11087, 11086, 11088, 11089, 11099, 11098, 11102, 11101, 11100, 11097, 11109, 11107, 11106, 11108, 11105, 11104, 11103, 11093, 11092, 11094, 11096, 11095, 11112, 11114, 11115, 11113, 11110, 11118, 11116, 11117, 11111, 11152, 11153, 11148, 11151, 11149, 11146, 11145, 11150, 11147, 11143, 11137, 11134, 11135, 11136, 11139, 11142, 11138, 11140, 11141, 11144, 11124, 11125, 11123, 11129, 11128, 11127, 11121, 11126, 11122, 11131, 11130, 11132, 11133, 11189, 11187, 11188, 11190, 11182, 11178, 11174, 11177, 11160, 11171, 11172, 11176, 11173, 11157, 11158, 11156, 11164, 11165, 11169, 11167, 11166, 11170, 11168, 11162, 11161, 11159, 11184, 11183, 11185, 11186, 11179, 11181, 11180, 11205, 11204, 11206, 11203, 11214, 11215, 11216, 11210, 11209, 11207, 11208, 11211, 11212, 11213, 11197, 11194, 11196, 11195, 11192, 11193, 11198, 11191, 11202, 11199, 11200, 11201, 11218, 11217, 11219, 11220, 11222, 11221, 11223, 11226, 11227, 11228, 11229, 11230, 11232, 11233, 11231, 11224, 11225, 11298, 11294, 11293, 11297, 11295, 11296, 11299, 11290, 11291, 11292, 11287, 11288, 11286, 11289, 11285, 11283, 11284, 11279, 11281, 11282, 11280, 11314, 11305, 11307, 11306, 11308, 11309, 11310, 11312, 11311, 11302, 11304, 11303, 11301, 11313, 11300, 11329, 11327, 11328, 11315, 11321, 11320, 11316, 11322, 11323, 11319, 11318, 11317, 11330, 11326, 11324, 11325, 11234, 11241, 11237, 11235, 11239, 11240, 11238, 11236, 11244, 11242, 11243, 11261, 11259, 11260, 11266, 11252, 11249, 11250, 11251, 11264, 11262, 11263, 11255, 11253, 11254, 11265, 11258, 11256, 11257, 11248, 11245, 11246, 11247, 11267, 11275, 11268, 11274, 11270, 11271, 11272, 11269, 11273, 11276, 11277, 11278, 11343, 11344, 11345, 11346, 11338, 11337, 11339, 11340, 11336, 11331, 11333, 11332, 11334, 11335, 11342, 11341, 11348, 11349, 11353, 11352, 11356, 11355, 11358, 11359, 11357, 11347, 11354, 11350, 11351, 11401, 11402, 11404, 11403, 11409, 11410, 11411, 11412, 11407, 11406, 11405, 11400, 11397, 11395, 11396, 11398, 11399, 11408, 11394, 11391, 11392, 11393, 11390, 11371, 11376, 11375, 11379, 11372, 11374, 11373, 11378, 11380, 11377, 11389, 11385, 11386, 11383, 11384, 11381, 11387, 11388, 11382, 11360, 11366, 11363, 11370, 11367, 11369, 11368, 11365, 11364, 11362, 11361, 11414, 11413, 11416, 11415, 11454, 11453, 11455, 11457, 11456, 11458, 11441, 11440, 11442, 11438, 11437, 11439, 11435, 11434, 11436, 11459, 11447, 11446, 11448, 11444, 11443, 11445, 11450, 11449, 11451, 11421, 11420, 11422, 11418, 11417, 11419, 11423, 11424, 11426, 11425, 11427, 11432, 11431, 11433, 11429, 11428, 11430, 11452, 11460, 11481, 11483, 11482, 11498, 11494, 11493, 11495, 11497, 11496, 11485, 11484, 11486, 11488, 11487, 11489, 11492, 11491, 11490, 11499, 11463, 11461, 11462, 11479, 11465, 11464, 11466, 11478, 11476, 11475, 11471, 11470, 11472, 11468, 11467, 11469, 11474, 11473, 11477, 11480, 11513, 11510, 11512, 11511, 11507, 11505, 11509, 11508, 11504, 11506, 11502, 11503, 11500, 11501, 11522, 11523, 11524, 11535, 11536, 11525, 11526, 11529, 11530, 11531, 11532, 11533, 11534, 11527, 11528, 11517, 11521, 11520, 11518, 11519, 11537, 11514, 11515, 11516, 11603, 11596, 11597, 11598, 11602, 11604, 11599, 11600, 11601, 11607, 11605, 11606, 11542, 11543, 11541, 11538, 11540, 11539, 11570, 11569, 11573, 11544, 11548, 11545, 11546, 11547, 11549, 11550, 11551, 11561, 11562, 11563, 11564, 11565, 11566, 11567, 11568, 11559, 11553, 11558, 11560, 11552, 11571, 11572, 11554, 11555, 11556, 11557, 11595, 11574, 11577, 11575, 11576, 11578, 11579, 11581, 11580, 11584, 11583, 11585, 11582, 11586, 11587, 11588, 11589, 11590, 11591, 11594, 11592, 11593, 11617, 11621, 11619, 11622, 11620, 11623, 11618, 11616, 11624, 11655, 11635, 11634, 11633, 11632, 11631, 11630, 11629, 11628, 11627, 11626, 11625, 11644, 11643, 11642, 11641, 11640, 11639, 11638, 11637, 11636, 11608, 11609, 11610, 11613, 11611, 11612, 11614, 11615, 11654, 11653, 11652, 11651, 11650, 11649, 11648, 11647, 11646, 11645, 11727, 11730, 11729, 11723, 11719, 11720, 11721, 11722, 11715, 11724, 11725, 11728, 11733, 11732, 11716, 11717, 11718, 11726, 11731, 11852, 11745, 11752, 11747, 11748, 11746, 11750, 11749, 11751, 11847, 11851, 11850, 11849, 11848, 11734, 11738, 11741, 11743, 11740, 11739, 11735, 11736, 11742, 11737, 11744, 11837, 11753, 11846, 11845, 11824, 11843, 11839, 11838, 11840, 11842, 11841, 11844, 11853, 11972, 11869, 11858, 11860, 11859, 11857, 11856, 11855, 11861, 11862, 11863, 11865, 11868, 11867, 11866, 11970, 11971, 11875, 11912, 11911, 11908, 11918, 11901, 11889, 11921, 11923, 11910, 11914, 11909, 11897, 11906, 11893, 11898, 11920, 11892, 11894, 11896, 11888, 11891, 11924, 11890, 11902, 11926, 11922, 11917, 11904, 11913, 11907, 11925, 11900, 11916, 11919, 11903, 11915, 11895, 11899, 11905, 11877, 11883, 11878, 11884, 11887, 11879, 11882, 11886, 11881, 11880, 11960, 11963, 11945, 11938, 11931, 11942, 11927, 11946, 11934, 11967, 11959, 11950, 11940, 11961, 11964, 11954, 11948, 11930, 11928, 11937, 11943, 11941, 11949, 11929, 11956, 11962, 11939, 11966, 11932, 11952, 11947, 11957, 11955, 11936, 11965, 11958, 11944, 11953, 11951, 11933, 11969, 11968, 11874, 11872, 11873, 11871, 11870, 11854, 11714, 11702, 11701, 11703, 11704, 11697, 11695, 11694, 11696, 11693, 11708, 11707, 11705, 11706, 11660, 11658, 11665, 11661, 11662, 11664, 11656, 11663, 11659, 11657, 11711, 11709, 11712, 11713, 11710, 11666, 11682, 11684, 11685, 11683, 11689, 11687, 11686, 11688, 11691, 11692, 11669, 11668, 11667, 11690, 11681, 11675, 11673, 11676, 11680, 11674, 11678, 11677, 11679, 11671, 11672, 11670, 11698, 11699, 11700, 11977, 11973, 11976, 11975, 11974, 11979, 11980, 11978, 11997, 11986, 11981, 11982, 11984, 11983, 11985, 11987, 11992, 11993, 11996, 11994, 11995, 11988, 11989, 11991, 11990, 12007, 12006, 12009, 12008, 12004, 12005, 12003, 11998, 12001, 11999, 12000, 12002, 12015, 12012, 12016, 12013, 12014, 12010, 12011, 12017, 12059, 12060, 12061, 12062, 12063, 12064, 12065, 12058, 12056, 12055, 12057, 12047, 12048, 12049, 12034, 12036, 12035, 12037, 12038, 12039, 12040, 12046, 12042, 12044, 12041, 12045, 12043, 12051, 12050, 12053, 12052, 12054, 12023, 12025, 12029, 12026, 12027, 12028, 12024, 12031, 12019, 12018, 12022, 12020, 12021, 12030, 12033, 12032, 12075, 12076, 12077, 12072, 12069, 12071, 12068, 12067, 12070, 12073, 12079, 12078, 12080, 12074, 12081, 12150, 12151, 12147, 12148, 12149, 12143, 12144, 12141, 12145, 12146, 12142, 12139, 12140, 12136, 12132, 12134, 12138, 12137, 12133, 12135, 12160, 12161, 12083, 12084, 12082, 12085, 12158, 12156, 12157, 12153, 12154, 12152, 12155, 12124, 12123, 12126, 12127, 12129, 12128, 12125, 12105, 12106, 12107, 12108, 12109, 12110, 12111, 12112, 12113, 12114, 12115, 12116, 12117, 12118, 12119, 12120, 12121, 12122, 12130, 12086, 12087, 12098, 12099, 12102, 12101, 12100, 12104, 12103, 12088, 12094, 12090, 12093, 12097, 12091, 12092, 12096, 12095, 12089, 12131, 12187, 12189, 12192, 12190, 12191, 12188, 12193, 12194, 12179, 12172, 12166, 12169, 12165, 12170, 12171, 12168, 12167, 12181, 12175, 12173, 12174, 12178, 12176, 12177, 12180, 12163, 12164, 12162, 12182, 12186, 12183, 12184, 12185, 12208, 12198, 12199, 12200, 12197, 12205, 12206, 12204, 12203, 12201, 12202, 12207, 12214, 12210, 12211, 12212, 12213, 12209, 12195, 12196, 12250, 12255, 12251, 12252, 12253, 12254, 12230, 12229, 12233, 12232, 12235, 12234, 12237, 12236, 12239, 12238, 12240, 12243, 12241, 12242, 12231, 12228, 12227, 12244, 12245, 12249, 12246, 12247, 12248, 12225, 12217, 12218, 12215, 12220, 12221, 12219, 12226, 12222, 12223, 12224, 12268, 12269, 12266, 12267, 12256, 12259, 12258, 12257, 12260, 12261, 12265, 12264, 12263, 12262, 12281, 12282, 12283, 12284, 12275, 12277, 12273, 12271, 12272, 12274, 12279, 12276, 12278, 12285, 12286, 12280, 12327, 12325, 12329, 12328, 12326, 12322, 12323, 12324, 12330, 12331, 12289, 12288, 12290, 12292, 12291, 12293, 12302, 12304, 12307, 12306, 12305, 12303, 12297, 12298, 12299, 12295, 12294, 12296, 12300, 12308, 12301, 12309, 12310, 12345, 12339, 12340, 12341, 12338, 12342, 12343, 12344, 12346, 12336, 12333, 12334, 12335, 12332, 12337, 12355, 12353, 12352, 12351, 12354, 12347, 12350, 12349, 12348, 12311, 12319, 12320, 12321, 12315, 12314, 12317, 12316, 12312, 12313, 12318, 12356, 12357, 12358, 12359, 12360, 12361, 12362, 12363, 12364, 12367, 12366, 12365, 12379, 12368, 12369, 12370, 12371, 12372, 12373, 12374, 12375, 12376, 12378, 12395, 12399, 12398, 12396, 12397, 12400, 12380, 12381, 12383, 12382, 12388, 12386, 12384, 12387, 12389, 12385, 12391, 12390, 12392, 12393, 12394, 12426, 12425, 12424, 12433, 12428, 12429, 12427, 12430, 12431, 12432, 12411, 12412, 12410, 12437, 12435, 12436, 12434, 12402, 12408, 12403, 12405, 12409, 12406, 12404, 12407, 12414, 12422, 12421, 12419, 12415, 12420, 12416, 12418, 12413, 12417, 12423, 12401, 13122, 13123, 13135, 13136, 13126, 13131, 13130, 13132, 13134, 13133, 13124, 13127, 13125, 13129, 13128, 13159, 13165, 13166, 13164, 13169, 13167, 13168, 13170, 13171, 13172, 13150, 13140, 13142, 13138, 13139, 13137, 13148, 13143, 13144, 13145, 13146, 13147, 13149, 13141, 13158, 13153, 13152, 13151, 13155, 13154, 13161, 13163, 13162, 13160, 13156, 13157, 13195, 13173, 13174, 13175, 13176, 13179, 13190, 13181, 13182, 13180, 13186, 13185, 13183, 13184, 13188, 13178, 13177, 13191, 13192, 13193, 13194, 13197, 13198, 13196, 13214, 13199, 13200, 13201, 13203, 13211, 13205, 13206, 13204, 13210, 13209, 13207, 13208, 13212, 13202, 13213, 13216, 13215, 13219, 13228, 13222, 13223, 13221, 13227, 13226, 13224, 13225, 13229, 13220, 13230, 13218, 13217, 13231, 13232, 13234, 13233, 13236, 13235, 13237, 13239, 13238, 13245, 13244, 13243, 13242, 13241, 13240, 13246, 13247, 13250, 13255, 13257, 13252, 13254, 13251, 13253, 13256, 13249, 13248, 13258, 13277, 13276, 13286, 13284, 13285, 13282, 13283, 13261, 13262, 13259, 13263, 13260, 13274, 13275, 13287, 13291, 13290, 13289, 13288, 13270, 13269, 13266, 13267, 13268, 13265, 13264, 13313, 13314, 13319, 13315, 13316, 13317, 13318, 13292, 13293, 13304, 13306, 13300, 13305, 13294, 13299, 13295, 13298, 13297, 13296, 13303, 13302, 13301, 13308, 13309, 13307, 13310, 13312, 13311, 13273, 13272, 13271, 13389, 13390, 13391, 13392, 13323, 13324, 13322, 13325, 13327, 13320, 13326, 13321, 13393, 13333, 13334, 13336, 13332, 13338, 13339, 13335, 13337, 13331, 13330, 13344, 13343, 13341, 13342, 13340, 13329, 13328, 13345, 13369, 13365, 13364, 13363, 13362, 13361, 13360, 13359, 13371, 13366, 13367, 13370, 13368, 13372, 13351, 13352, 13349, 13350, 13348, 13356, 13354, 13357, 13358, 13355, 13353, 13346, 13347, 13374, 13375, 13376, 13373, 13377, 13378, 13379, 13387, 13386, 13385, 13388, 13380, 13384, 13383, 13382, 13381, 13423, 13416, 13414, 13415, 13413, 13394, 13419, 13395, 13405, 13417, 13418, 13420, 13411, 13421, 13412, 13422, 13406, 13410, 13407, 13408, 13409, 13404, 13403, 13396, 13397, 13399, 13398, 13402, 13400, 13401, 13429, 13426, 13427, 13425, 13424, 13428, 13430, 13445, 13446, 13447, 13450, 13448, 13449, 13444, 13439, 13433, 13431, 13434, 13432, 13441, 13440, 13442, 13438, 13435, 13436, 13437, 13443, 13457, 13451, 13456, 13453, 13455, 13454, 13452, 13480, 13488, 13478, 13479, 13483, 13481, 13482, 13484, 13486, 13487, 13485, 13476, 13475, 13473, 13477, 13474, 13472, 13461, 13462, 13460, 13459, 13463, 13458, 13471, 13469, 13468, 13470, 13466, 13465, 13467, 13464, 13489, 13494, 13490, 13491, 13492, 13493, 13495, 13496, 13497, 13500, 13499, 13501, 13505, 13504, 13502, 13503, 13498 )
                                       


감사합니다.
이 글에 대한 댓글이 총 2건 있습니다.

조건 내용을 임시 테이블에 넣어놓고 조인하시던가 하세요.....

지나가다가님이 2009-10-17 17:29에 작성한 댓글입니다. Edit

안녕하세요

아래와 같이 처리가능할 것 같습니다.

declare @t table (idx int)

insert into @t values (7974)
insert into @t values (7975)
insert into @t values (7976)
insert into @t values (7977) 
......

select * from CONTENTS_VIEW  V inner join @t t2 on V.idx  = t2.idx

구광모(kkm0802)님이 2009-10-19 10:19에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
5420쿼리문좀 작성해주세요.. 고수님들... [1]
이호상
2009-10-22
5305
5419getDate로 지난달을 가져올수 있나요? [1]
래시
2009-10-19
6613
5418MSSQL 2005 퀴리문 질문입니다. [1]
김창현
2009-10-18
6355
5417where의 조건이 많을 때 오류 [2]
황운호
2009-10-16
7770
5416최대값 가져오기 도와주세요 [1]
이흥도
2009-10-14
5690
5415쿼리좀 봐주세요 [1]
허접
2009-10-13
5441
5414회원 전년대비 전월대비 통계구하는법
답답맨
2009-10-13
6890
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.025초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다