Á¶°ÇÀý¿¡ ´ëÇؼ ¹®Àǵ帳´Ï´Ù.
AND A.CD_ACCT IN (SELECT NVL(CD_STR,A.CD_ACCT) FROM TABLE (GETTABLEFROMSPLIT(@CD_ACCT)))
ÀÌ·¸°Ô Çϴϱñ Àüü¸¦ Á¶È¸ÇÒ¶§ °ªÀÌ null ÀÎ ¾Ö°¡ Á¶È¸°¡ ¾ÈµÇ´øµ¥
¾î¶»°Ô ¼öÁ¤ÇØ¾ß ÇÒ±î¿ä?
ȸ°èÁ÷¿øÀε¥ »ç¿ëÀÚ°¡ Á÷Á¢ Äõ¸®¸¦ µî·ÏÇؼ Á¶È¸¸Þ´º¸¦ ¸¸µé¼ö Àִµ¥ Àú±â¼ ¸·È÷³×¿ä ¤Ð¤Ð
°³¹ßÀ» ¹è¿ö¾ß Çϳª ½Í³×¿ä ¤Ð¤Ð
AND ((±âÁ¸Á¶°Ç) OR A.CD_ACCT IS NULL)
´äº¯ÁֽŴë·Î Çϴϱñ º¯¼ö°¡ ÁöÁ¤ÀÌ µÆÀ»¶§µµ NULL °ªÀ» Ãâ·ÂÇؼ¿ä
º¯¼ö°¡ ÁöÁ¤µÇ¸é ÁöÁ¤µÈ °ª¸¸ Ãâ·ÂÇÏ·Á¸é ¾î¶»°Ô ¼öÁ¤ÇØ¾ß ÇÒ±î¿ä?
AND ((A.CD_PJT IN (SELECT NVL(CD_STR,A.CD_PJT) FROM TABLE (GETTABLEFROMSPLIT(@CD_PJT)))) OR A.CD_PJT IS NULL)
º¯¼ö°¡ ÁöÁ¤ µÆÀ»¶§¶ó´Â°Ô ¹«½¼ Àǹ̽DZî¿ä? Äõ¸®¿¡¼´Â A.CD_PJT = ? ÀÌ·±½ÄÀ¸·Î ÆĶó¹ÌÅ͸¦ ºñ±³ÇÏ´Â ºÎºÐÀº ¾ø¾îº¸À̴µ¥.. Ȥ½Ã @CD_PJT°¡ ÀԷ¹޴ º¯¼öÀΰ¡¿ä
@¾Æ·ÎÅ°
³× ¸Â½À´Ï´Ù.
@¼¼±ÝÁ»¸¹¾Æ ±×·¯¸é ±×³É º»¹® Á¶°Ç ´ÙÀ½¿¡
OR @º¯¼ö IS NULL
ÀÌ·¸°Ô Çغ¸¼¼¿ä
nullÀº ºñ±³ÇÒ¼ö ¾ø´Â °ªÀÔ´Ï´Ù.
and (a.cd_acct is null or a.cd_acct in (
¼ºêÄõ¸®))
¿ä·¸°Ô Çϸé ÀǵµÇϽô µ¥ÀÌÅÍ Àϵí
´äº¯ÁֽŴë·Î ÇÏ´Ï ¿ì°ýÈ£°¡ ´©¶ôµÆ´Ù°í Çϴµ¥ ÀÌÀ¯¸¦ ¸ð¸£°Ú¾î¿ä
and (a.CD_PJT is null or a.CD_PJT in (A.CD_PJT IN (SELECT NVL(CD_STR,A.CD_PJT) FROM TABLE (GETTABLEFROMSPLIT('')))))
AND ((±âÁ¸Á¶°Ç) OR A.CD_ACCT IS NULL)
´äº¯ÁֽŴë·Î Çϴϱñ º¯¼ö°¡ ÁöÁ¤ÀÌ µÆÀ»¶§µµ NULL °ªÀ» Ãâ·ÂÇؼ¿ä
º¯¼ö°¡ ÁöÁ¤µÇ¸é ÁöÁ¤µÈ °ª¸¸ Ãâ·ÂÇÏ·Á¸é ¾î¶»°Ô ¼öÁ¤ÇØ¾ß ÇÒ±î¿ä?
AND ((A.CD_PJT IN (SELECT NVL(CD_STR,A.CD_PJT) FROM TABLE (GETTABLEFROMSPLIT(@CD_PJT)))) OR A.CD_PJT IS NULL)
º¯¼ö°¡ ÁöÁ¤ µÆÀ»¶§¶ó´Â°Ô ¹«½¼ Àǹ̽DZî¿ä? Äõ¸®¿¡¼´Â A.CD_PJT = ? ÀÌ·±½ÄÀ¸·Î ÆĶó¹ÌÅ͸¦ ºñ±³ÇÏ´Â ºÎºÐÀº ¾ø¾îº¸À̴µ¥.. Ȥ½Ã @CD_PJT°¡ ÀԷ¹޴ º¯¼öÀΰ¡¿ä
@¾Æ·ÎÅ°
³× ¸Â½À´Ï´Ù.
@¼¼±ÝÁ»¸¹¾Æ ±×·¯¸é ±×³É º»¹® Á¶°Ç ´ÙÀ½¿¡
OR @º¯¼ö IS NULL
ÀÌ·¸°Ô Çغ¸¼¼¿ä