|
|
|
|
Leader / 2001-12-19 / ¿ÀÀü 8:02:23 / 211.189.136.10
Á¶È¸¼ö : 133
|
[Áú¹®] ¤¾¤¾¤¾ Áú¹® -_-;;
|
>
> strSQLFind="insert into groupadmin.APPROVAL_TABLE (DEPTNO, APP_NAME, SEQNO, EMPNO)"
> strSQLFind=strSQLFind & " "
> strSQLFind=strSQLFind & " select ºÎ¼CODE,'"&approverPath&"',"&s&","&ApproverID&" from openquery(stc,'select ºÎ¼CODE from Àλç_ÃÖ±Ù¹ß·É Where »çÁ÷ÀÏÀÚ Is Null and »ç¹ø=''"&AppID&"''')"
>
>
> ÀÏ´Ü Àú¹øºÎÅÍ ±×·¨´ø°Çµ¥... ÀÌ ºÎºÐ¿¡¼ from µÚ¿¡ ÀÖ´Â
>
> openquery¶ó´Â°Ô ¹» ÀǹÌÇÏ´Â °Ç°¡¿ä?
>
> ÇÔ¼öÀΰ¡¿ä? ±×·³ ±× µÞºÎºÐÀº ¹» ÀǸ¶Çϴ°ǰ¡¿ä?
>
> ±×¸®°í openquery ¾È¿¡ »ç¹ø = ´ÙÀ½¿¡´Â ¿Ö ÀÛÀº µû¿ÈÇ¥°¡ 2°³¾¿ µé¾î°¬³ª¿ä?
>
> ±×¸®°í strSQLFind=strSQLFind & " select ºÎ¼CODE,'"&approverPath&"',"&s&","&ApproverID&" from
>
> ÀÌ ¹®Àå¿¡¼´Â approverPath º¯¼ö ÁÖÀ§¿¡ ÀÖ´Â ÀÛÀº µû¿ÈÇ¥´Â ºÒÇÊ¿ä ÇÑ°Í °°Àºµ¥¿ä...
>
> ±×¸®°í Àú¹ø¿¡µµ ¸»¾¸ µå·È´Âµ¥... Áú¹°À» ÇϽǶ§´Â
>
> ±×³É ¾È µÇ´Âµ¥¿ä ÀûÀ¸¸é ¾È µÇ°í¿ä.....
>
> ¾îµð¼ ¾î¶»°Ô ¾È µÇ´ÂÁö¸¦ Àû¾î¾ß¸¸ ´äº¯ÀÌ °¡´ÉÇÕ´Ï´Ù....
>
> ¿¡·¯°¡ ³ª´ÂÁö ¾Æ´Ï¸é ¿¡·¯´Â ¾È ³ª´Âµ¥ ³í¸®ÀûÀ¸·Î ¿øÇÏ´Â ´äÀÌ ¾È ³ª¿À´ÂÁö
>
> ¿¡·¯°¡ ³´Ù¸é ¾î¶² ¿¡·¯°¡ ³ª´ÂÁö¸¦ Àû¾î Áּž߸¸ ´Ù¸¥ ºÐµéÀÌ
>
> ¸®´õ´ÔÀÇ Áú¹®À» ÀÌÇØÇÒ ¼ö ÀÖ°ÚÁÒ... ¾ó±¼ ¸Â´ë°í À̾߱âÇÏ´Â °Íµµ ¾Æ´Ï°í ¸»ÀÌ¿¹¿ä... ^^
>
> ³Ñ ¹«¸®ÇÏÁö ¸¶½Ã°í ½¬¾ö½¬¾ö Çϼ¼¿ä~~
>
>
-----------------------------------------------------------
¾Æ... ¼³¸íÀ» Çص帱°Ô¿ä...
SQL°ú ORACLE À» °°ÀÌ ¿¬°áÇؼ »ç¿ëÀ» Çϴµ¥¿ä...
ORACLEÀ» SQL¿¡¼ Á÷Á¢ Äõ¸®¸¦ ÇÏ·Á¸é...
SELECT * FROM OPENQUERY(¿À¶óŬ¼¹öÀ̸§,'Äõ¸®¹®')
ÀÌ·± Çü½ÄÀ¸·Î ¾´´ä´Ï´Ù...
¸¸¾à...¿À¶óŬ¿¡ AAAA¶ó´Â Å×ÀÌºí¿¡¼ ¡º¼¼ÀÚ¡»¶ó´Â
°É ãÀ¸·Á¸é...
SELECT * FROM OPENQUERY(¿À¶óŬ¼¹öÀ̸§,'SELECT * FROM AAAA WHERE NAME = ''¼¼ÀÚ''')
ÀÌ·¸°Ô Çؾߵǰŵç¿ä...
¤Ñ¤Ñ;;; ÄõÅ×À̼ÇÀ» µÎ°³¾¿ ºÙ¿©Áà¾ßÇØ¿ä...
¿¡ÈË...
Á¦°¡ ¾ÈµÇ´Â ºÎºÐÀº...
str = "2000066,2000001,2000066,2000002,2000003,2000004,"
ÀÌ°ªÀÌ ³ª¿À´Â °÷¿¡¼...
½ºÇÁ¸®Æ®·Î ÂÉ°³°í....
appID = split(str,",")
·çÇÁ¸¦ µ¹·Á¼....
s=0
do until s<ubound(appId)
appID(s) <==¿ä°í ÀúÀå...
ÀμƮ¹®...
loop
ÀÌ·±½ÄÀ¸·Î... Â÷·ÊÂ÷·Ê ÀúÀåÀ» ÇÏ°í ½Í¾î¿ä...
±×·±µ¥... -_-;; ±×³É ÆäÀÌÁö¿¡ ¿À·ù´Â ¾È³ª´Âµ¥...
-_-;; Å×À̺íÀ» º¸¸é µ¥ÀÌÅÍ°¡ ¾Èµé¾î°¡ÀÖ¾î¿ä...
¤Ñ_¤Ì
|
|
|
|