¥Ô¥Ü¥Ã¥È¡ÊPIVOT¡Ë¤ÏJ¡¦W¡¦¥ï¥¤¥ë¥À¡¼¤Ë¤è¤Ã¤Æ¹Í°Æ¤µ¤ì¤¿¥Æ¥¯¥Ë¥«¥ë»ØÉ¸¤Ç¤¹¡£
û´üÇäÇã¤ÎµÕÄ¥¤ê¤ËŬ¤·¤Æ¤¤¤ë¥Æ¥¯¥Ë¥«¥ë¤Ç¤¹¡£
ÅöÁ³¤É¤ó¤Ê¥Æ¥¯Æó¥«¥ë¤Ç¤â¤½¤¦¤Ç¤¹¤¬¡¢Ëè²ó¤¦¤Þ¤¯¤¤¤¯¤ï¤±¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
¤¤Á¤ó¤È¤·¤¿¼«¸Ê¥ë¡¼¥ë¤ò¼é¤é¤Ê¤¤¤È¤¤¤±¤Þ¤»¤ó¡£
¸Ä¿Íº¹¤¬¤¢¤ê¡¢ÆÈ¼«¤ÎÇäÇãÊýË¡¤òÍѤ¤¤Æ¤¤¤ëÊý¤â¿¤¤¤Ç¤¹¡£
¤Ç¤â¡¢¤³¤ÎÊýË¡¤Ç²Ô¤¤¤Ç¤¤¤ëÊý¤¬Â¿¤¯¸«¼õ¤±¤é¤ì¤Þ¤¹¡£
¸¡¾Ú¤·¤Æ¤¤¤¤¿¤¤¤Î¤Ç¤¹¤¬¡¢ºÇ¶á¤Ï±ß¹â¾ìÌ̤¬Â¿¤¯¡¢¸«Á÷¤ê¤·¤Æ¤Þ¤·¤¿¡£
¤½¤í¤½¤í¥ì¥ó¥¸Áê¾ì¤«¡©¡©¡©
¥¹¥ï¥Ã¥×°ÙÂØ¥Ö¥í¥°¥é¥ó¥¥ó¥°
û´üÇäÇã¤ÎµÕÄ¥¤ê¤ËŬ¤·¤Æ¤¤¤ë¥Æ¥¯¥Ë¥«¥ë¤Ç¤¹¡£
ÅöÁ³¤É¤ó¤Ê¥Æ¥¯Æó¥«¥ë¤Ç¤â¤½¤¦¤Ç¤¹¤¬¡¢Ëè²ó¤¦¤Þ¤¯¤¤¤¯¤ï¤±¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
¤¤Á¤ó¤È¤·¤¿¼«¸Ê¥ë¡¼¥ë¤ò¼é¤é¤Ê¤¤¤È¤¤¤±¤Þ¤»¤ó¡£
¸Ä¿Íº¹¤¬¤¢¤ê¡¢ÆÈ¼«¤ÎÇäÇãÊýË¡¤òÍѤ¤¤Æ¤¤¤ëÊý¤â¿¤¤¤Ç¤¹¡£
¤Ç¤â¡¢¤³¤ÎÊýË¡¤Ç²Ô¤¤¤Ç¤¤¤ëÊý¤¬Â¿¤¯¸«¼õ¤±¤é¤ì¤Þ¤¹¡£
¸¡¾Ú¤·¤Æ¤¤¤¤¿¤¤¤Î¤Ç¤¹¤¬¡¢ºÇ¶á¤Ï±ß¹â¾ìÌ̤¬Â¿¤¯¡¢¸«Á÷¤ê¤·¤Æ¤Þ¤·¤¿¡£
¤½¤í¤½¤í¥ì¥ó¥¸Áê¾ì¤«¡©¡©¡©
¥¹¥ï¥Ã¥×°ÙÂØ¥Ö¥í¥°¥é¥ó¥¥ó¥°
»È¤¦¤Î¤Ï¡¢Á°Æü¤Î¹âÃÍ¡¢°ÂÃÍ¡¢½ªÃͤÀ¤±
¤³¤Î3 ¤Ä¤Î¥Ç¡¼¥¿¤ò¤·¤Æ3 ¤Ç³ä¤Ã¤¿¿ôÃͤò¥Ô¥Ý¥Ã¥È¡ÊP¡Ë¤ÈÄêµÁ¤·¤Æ¤¤¤Æ
¥µ¥Ý¡¼¥È¡¦¥ì¥¸¥¹¥¿¥ó¥¹¤Î¿ôÃͤò»»½Ð¤·¤Þ¤¹¡£
*¥Ô¥Ü¥Ã¥È¡ÊP¡Ë¡á¡ÊÁ°Æü¹âÃÍ¡ÜÁ°Æü°ÂÃÍ¡ÜÁ°Æü½ªÃ͡ˡà3
¥µ¥Ý¡¼¥È¥é¥¤¥ó1¡ÊS1¡Ë ¡áP¡ß2-Á°Æü¹âÃÍ
¥ì¥¸¥¹¥¿¥ó¥¹¥é¥¤¥ó1(R1)¡áP¡ß2-Á°Æü°ÂÃÍ
¥µ¥Ý¡¼¥È¥é¥¤¥ó2 (S2) ¡¡¡áP-¡ÊR1-S1¡Ë
¥ì¥¸¥¹¥¿¥ó¥¹¥é¥¤¥ó2(R2)¡áP¡Ü(R1-S1)
°ÙÂØ¤òÎã¤Ë¼è¤ê¶ñÂÎŪ¤Ê¿ô»ú¤òÆþ¤ì¤Æ¤ß¤Þ¤·¤ç¤¦
³ô¼°¤Ç¤â±þÍѤǤ¤Þ¤¹¡£
¥ì¥¸¥¹¥¿¥ó¥¹¥é¥¤¥ó2(R2)
¥ì¥¸¥¹¥¿¥ó¥¹¥é¥¤¥ó1(R1)
»ÏÃÍ
¥µ¥Ý¡¼¥È¥é¥¤¥ó1¡ÊS1¡Ë
¥µ¥Ý¡¼¥È¥é¥¤¥ó2 (S2) ¡¡
¤³¤Î¤è¤¦¤Ë¿ô»ú¤¬Ê¤Ӥޤ¹¡£
S1¡¦S2¤ÇÇ㤤¢ªR1¡¦R2¤ÇÇä¤ê ´ðËܥ饤¥ó¤Ç¤¹
µÞ·ã¤Ê±ß¹â¡¦±ß°Â¤Ç¤Ï±þÍÑÍø¤«¤Ê¤¤¤¿¤á¡¢¥í¥¹¥«¥Ã¥È¤ò¤¤¤ì¤ÆË¾¤ß¤Þ¤·¤ç¤¦
¤Þ¤¿¡¢ËèÆü¿ôÃͤ¬ÊѤï¤Ã¤Æ¤¤Þ¤¹¡£¤³¤Þ¤á¤ËÀßÄꤷ¤Þ¤·¤ç¤¦
¥¹¥ï¥Ã¥×°ÙÂØ¥Ö¥í¥°¥é¥ó¥¥ó¥°
¤³¤Î3 ¤Ä¤Î¥Ç¡¼¥¿¤ò¤·¤Æ3 ¤Ç³ä¤Ã¤¿¿ôÃͤò¥Ô¥Ý¥Ã¥È¡ÊP¡Ë¤ÈÄêµÁ¤·¤Æ¤¤¤Æ
¥µ¥Ý¡¼¥È¡¦¥ì¥¸¥¹¥¿¥ó¥¹¤Î¿ôÃͤò»»½Ð¤·¤Þ¤¹¡£
*¥Ô¥Ü¥Ã¥È¡ÊP¡Ë¡á¡ÊÁ°Æü¹âÃÍ¡ÜÁ°Æü°ÂÃÍ¡ÜÁ°Æü½ªÃ͡ˡà3
¥µ¥Ý¡¼¥È¥é¥¤¥ó1¡ÊS1¡Ë ¡áP¡ß2-Á°Æü¹âÃÍ
¥ì¥¸¥¹¥¿¥ó¥¹¥é¥¤¥ó1(R1)¡áP¡ß2-Á°Æü°ÂÃÍ
¥µ¥Ý¡¼¥È¥é¥¤¥ó2 (S2) ¡¡¡áP-¡ÊR1-S1¡Ë
¥ì¥¸¥¹¥¿¥ó¥¹¥é¥¤¥ó2(R2)¡áP¡Ü(R1-S1)
°ÙÂØ¤òÎã¤Ë¼è¤ê¶ñÂÎŪ¤Ê¿ô»ú¤òÆþ¤ì¤Æ¤ß¤Þ¤·¤ç¤¦
³ô¼°¤Ç¤â±þÍѤǤ¤Þ¤¹¡£
¥ì¥¸¥¹¥¿¥ó¥¹¥é¥¤¥ó2(R2)
¥ì¥¸¥¹¥¿¥ó¥¹¥é¥¤¥ó1(R1)
»ÏÃÍ
¥µ¥Ý¡¼¥È¥é¥¤¥ó1¡ÊS1¡Ë
¥µ¥Ý¡¼¥È¥é¥¤¥ó2 (S2) ¡¡
¤³¤Î¤è¤¦¤Ë¿ô»ú¤¬Ê¤Ӥޤ¹¡£
S1¡¦S2¤ÇÇ㤤¢ªR1¡¦R2¤ÇÇä¤ê ´ðËܥ饤¥ó¤Ç¤¹
µÞ·ã¤Ê±ß¹â¡¦±ß°Â¤Ç¤Ï±þÍÑÍø¤«¤Ê¤¤¤¿¤á¡¢¥í¥¹¥«¥Ã¥È¤ò¤¤¤ì¤ÆË¾¤ß¤Þ¤·¤ç¤¦
¤Þ¤¿¡¢ËèÆü¿ôÃͤ¬ÊѤï¤Ã¤Æ¤¤Þ¤¹¡£¤³¤Þ¤á¤ËÀßÄꤷ¤Þ¤·¤ç¤¦
¥¹¥ï¥Ã¥×°ÙÂØ¥Ö¥í¥°¥é¥ó¥¥ó¥°
