ºÇ¶á¤Ï¿§¡¹¤¢¤ê¤¹¤®¤Æ¡¢È÷˺Ͽ¤Ë²¿¤ò»Ä¤·¤¿¤â¤ó¤«¤Ã¤Æ¥«¥ó¥¸¤Ë¤Ê¤ê¤Ä¤Ä¤¢¤ê¤Þ¤¹¡£
¤ªµÒ¤µ¤ó¤Ë¡¢BULK¤¸¤ã¤Ê¤¯¤ÆBIND¤ÇINSERT¤·¤Æ¤¯¤ì¡£¤Ê¡¼¤ó¤Æ¸À¤ï¤ì¤Þ¤·¤¿¤±¤É¡¢GoogleÀèÀ¸¤Ëʹ¤¤¤Æ¤â BIND INSERT ¤Ê¤ó¤Æ°ú¤Ã¤«¤«¤é¤Ê¤¤¤ó¤Ç¤¹¤è¤Í¤§¡£¡£
¤è¤¯¤ï¤«¤é¤Ê¤¤¤Þ¤Þ¡¢µ¤¤Å¤¤¤¿¤éBULK INSERT ¤ÇÏ䬿ʤó¤Ç¤Þ¤·¤¿¡£
¤Ê¤ó¤À¤Ã¤¿¤ó¤À¡Ä!!!!!!
¤È¤¤¤¦¤ï¤±¤Ç³Ð½ñ
¡¦¡Ö¼±ÊÌ»ÒA¡×¤È¡Ö¼±ÊÌ»ÒB¡×¤ò¥¡¼¤È¤·¤Æ¡¢¡Öɽ1¡×¤«¤é¡ÖSTART_YMD¡×¤ò¼èÆÀ¡£
¡¦¡Öɽ2¡×¤ò»²¾È¤·¡¢¾åµ¡ÖSTART_YMD¡×°ÊÁ°¤Ç¤â¤Ã¤È¤âľ¶á¤Î¡ÖEFFECT_YMD¡×¤ò»ý¤Ä¥Ç¡¼¥¿¤«¤é¡Ö¼±ÊÌ»ÒSP¡×¤òÀßÄê¡£
¾ò·ï£±¡¡EFFECT_YMD <=¡¡START_YMD
¾ò·ï£²¡¡¾ò·ï£±¤Î¡¡ºÇÂçÃÍ
¤Ä¤Þ¤ê¡¢¾ò·ïÆâ¤Ç¡¢ºÇÂçÃͤΥ쥳¡¼¥É¤ò¤È¤Ã¤Æ¤³¤ì¤Ð¤è¤¤¤ï¤±¤Ç¤¹¤Í¡£
SELECT ¼±ÊÌ»ÒSP
FROM ɽ2 ɽ2_A
WHERE ɽ2_A.͸ú³«»Ïǯ·îÆü = (
SELECT MAX(ɽ2_B.EFFECT_YMD)
FROM ɽ2 ɽ2_B
INNER JOIN ɽ1
ON ɽ2_B.EFFECT_YMD <= ɽ1.START_YMD
WHERE ɽ1.¼±ÊÌ»ÒA = 'TEST01'
AND ɽ1.¼±ÊÌ»Ò = 'TEST01'
);¤È¤«¤Ê¤ë¥ï¥±¤Ç¤¹¡ª
ÉûÌ䤤¹ç¤ï¤»¤ÇƱ¤¸É½»²¾È¤·¤Æ¤ë¤Î¤¬
¤è¤¤¤Î¤«°¤¤¤Î¤«¡£
¤â¤Ã¤È¤¤¤¤ÊýË¡¤¢¤ë¤Î¤«¤Ê¤¡¡Á¡Ä¡£