¥Ô¥Ü¥Ã¥È¡Ê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¤ÇÇä¤ê ´ðËܥ饤¥ó¤Ç¤¹


µÞ·ã¤Ê±ß¹â¡¦±ß°Â¤Ç¤Ï±þÍÑÍø¤«¤Ê¤¤¤¿¤á¡¢¥í¥¹¥«¥Ã¥È¤ò¤¤¤ì¤ÆË¾¤ß¤Þ¤·¤ç¤¦


¤Þ¤¿¡¢ËèÆü¿ôÃͤ¬ÊѤï¤Ã¤Æ¤­¤Þ¤¹¡£¤³¤Þ¤á¤ËÀßÄꤷ¤Þ¤·¤ç¤¦


¥¹¥ï¥Ã¥×°ÙÂØ¥Ö¥í¥°¥é¥ó¥­¥ó¥°