FIX: 2008 SQL Server ¶Ç´Â SQL Server 2008 r2¿¡¼­ »ðÀÔ ¼±Åà UNION ALL ¹®À» ½ÇÇà Çϸé À߸ø µÈ °á°ú

±â¼ú ÀÚ·á: 2530921 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
±â°è ¹ø¿ªµÈ ¹®¼­±â°è ¹ø¿ª °íÁö »çÇ× º¸±â

Microsoft ´Ù¿î·Îµå °¡´ÉÇÑ ÆÄÀÏ·Î Microsoft SQL Server 2008 Microsoft SQL Server 2008 R2 ¼­ºñ½º ÆÑ 1ÀÇ ¼öÁ¤ ÇÁ·Î±×·¥À» ¹èÆ÷ÇÕ´Ï´Ù. ¼öÁ¤ ´©Àû µÇ´Â ÇüÅ À̹ǷΠ°¢ »õ ¸±¸®½ºÀÇ ¸ðµç ÇÖÇȽº¿Í µé¾î ¹× ÀÌÀü SQL Server 2008 ¼­ºñ½º ÆÑ 1 ¶Ç´Â SQL Server 2008 r 2¿¡ Æ÷ÇÔ µÈ ¸ðµç º¸¾È ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¼öÁ¤.
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

Çö»ó

½ÇÇàÇÒ ¶§´Â ¸ðµç SELECT UNIONÀ» »ðÀÔ ÇÕ´Ï´Ù. 2008 SQL Server ¶Ç´Â SQL Server 2008 R2 ¹® ¹®ÀÇ °á°ú°¡ ¿Ã¹Ù¸£Áö ¾ÊÀ» ¼ö ¿øº» Å×À̺íÀÇ °æ¿ì´Â ¼±Åà ÀýÀÇ ´ë»ó Å×À̺í·Î »ç¿ë µÇ´Â »ðÀÔ ÀýÀÔ´Ï´Ù.

¿¹¸¦ µé¾î, ³× °³ÀÇ Å×À̺íÀ» ¸¸µé·Á¸é ´ÙÀ½ ¸í·É¹®À» ½ÇÇà ÇÕ´Ï´Ù. 
CREATE TABLE [TabA] (M VARCHAR(20), W VARCHAR(20)) 
CREATE TABLE [TabB] (M VARCHAR(20), W VARCHAR(20), R VARCHAR(20)) 
CREATE TABLE [TabC] (P VARCHAR(6), M CHAR(20), A NUMERIC(13)) 
CREATE TABLE [TabD] (P VARCHAR(6), W VARCHAR(20), M VARCHAR(20), D NUMERIC(13), E DATETIME, F DATETIME)
ÀϺΠ°ªÀ¸·Î »ðÀÔÀº »óȲº°, TabB¹× TabD Å×À̺íÀ» ¼±ÅÃÇÑ ´ÙÀ½ ´ÙÀ½À» ½ÇÇà ÇÕ´Ï´Ù. ¸ðµç SELECT UNIONÀ» »ðÀÔ ÇÕ´Ï´Ù. ¹®:

INSERT INTO [TabC] (P, M, A)
SELECT T1.P,T1.M,T1.D / SUM(1) OVER(PARTITION BY P) 
FROM [TabD] T1 INNER JOIN [TabA] T2 ON (T1.M = T2.M AND T1.W = T2.W) 
WHERE NOT EXISTS (SELECT * FROM [TabC] E1 WHERE T1.P = E1.P) 
UNION ALL
SELECT T1.P,T2.M,T1.D / SUM(1) OVER(PARTITION BY P) 
FROM [TabD] T1 INNER JOIN [TabB] T2 ON (T1.M = T2.R AND T1.W = T2.W) 
WHERE NOT EXISTS (SELECT * FROM [TabC] E1 WHERE T1.P = E1.P) 
GO
ÀÌ ½Ã³ª¸®¿À¿¡¼­´Â À߸ø µÈ °á°ú°¡ ³ªÅ¸³¯ ¹× ÀϺΠ·¹ÄÚµå À߸ø »ðÀÔ ÇÏÁö´Â TabC Å×À̺íÀÔ´Ï´Ù.

À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á ¹æ¹ý

´©Àû ¾÷µ¥ÀÌÆ® Á¤º¸

SQL Server 2008 R2

ÀÌ ¹®Á¦Á¡¿¡ ´ë ÇÑ ¼öÁ¤ ÇÁ·Î±×·¥Àº ¸ÕÀú ´©Àû ¾÷µ¥ÀÌÆ® 9¿¡ ¸±¸®½º µÇ¾ú½À´Ï´Ù. SQL Server 2008 r 2¿¡ ´ë ÇÑÀÌ ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¸¦ ±¸ÇÏ´Â ¹æ¹ý¿¡ ´ë ÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ ÇÕ´Ï´Ù.
2567713
(http://support.microsoft.com/kb/2567713/ )
SQL Server 2008 r 2¿¡ ´ë ÇÑ ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö 9
Âü°í ºôµå ´©Àû µÇ´Â ÇüÅ À̹ǷΠ°¢ »õ ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¸ðµç ÇÖÇȽº¿Í µé¾î ¹× ÀÌÀü SQL Server 2008 r2¿¡ Æ÷ÇÔ µÈ ¸ðµç º¸¾È ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¼öÁ¤. ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔ µÈ ÃֽŠ¼öÁ¤ ¸±¸®½º¸¦ Àû¿ëÀ» °í·Á ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ ÇϽʽÿÀ.
981356
(http://support.microsoft.com/kb/981356/ )
SQL Server 2008 r2¸¦ SQL Server 2008 r 2°¡ ¸±¸®½ºµÈ ÈÄ¿¡ ¸±¸®½ºµÈ ºôµå

SQL Server 2008 R2 ¼­ºñ½º ÆÑ 1

ÀÌ ¹®Á¦ÀÇ ¼öÁ¤ ÇÁ·Î±×·¥Àº ¸ÕÀú SQL Server 2008 R2 ¼­ºñ½º ÆÑ 1¿¡ ´ë ÇÑ ´©Àû ¾÷µ¥ÀÌÆ® 2 ¸±¸®½º µÇ¾ú½À´Ï´Ù. ÀÌ ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¸¦ ±¸ÇÏ´Â ¹æ¹ý¿¡ ´ë ÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ ÇÕ´Ï´Ù.
2567714
(http://support.microsoft.com/kb/2567714/ )
SQL Server 2008 R2 ¼­ºñ½º ÆÑ 1 ¿ë ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö 2
Âü°í ºôµå ´©Àû µÇ´Â ÇüÅ À̹ǷΠ°¢ »õ ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¸ðµç ÇÖÇȽº¿Í µé¾î ¹× ÀÌÀü SQL Server 2008 r2¿¡ Æ÷ÇÔ µÈ ¸ðµç º¸¾È ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¼öÁ¤. ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔ µÈ ÃֽŠ¼öÁ¤ ¸±¸®½º¸¦ Àû¿ëÀ» °í·Á ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ ÇϽʽÿÀ.
2567616
(http://support.microsoft.com/kb/2567616/ )
SQL Server 2008 r2¸¦ SQL Server 2008 R2 ¼­ºñ½º ÆÑ 1ÀÌ ¸±¸®½ºµÈ ÈÄ¿¡ ¸±¸®½ºµÈ ºôµå

SQL Server 2008 ¼­ºñ½º ÆÑ 2

ÀÌ ¹®Á¦Á¡¿¡ ´ë ÇÑ ¼öÁ¤ ÇÁ·Î±×·¥Àº ¸ÕÀú SQL Server 2008 ¼­ºñ½º ÆÑ 2¿¡ ´ë ÇÑ ´©Àû ¾÷µ¥ÀÌÆ® 5 ¸±¸®½º µÇ¾ú½À´Ï´Ù. ÀÌ ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¿¡ ´ë ÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ ÇÕ´Ï´Ù.
2555408
(http://support.microsoft.com/kb/2555408/LN/ )
SQL Server 2008 ¼­ºñ½º ÆÑ 2 ¿ë ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö 5
Âü°í ºôµå ´©Àû µÇ´Â ÇüÅ À̹ǷΠ°¢ »õ ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¸ðµç ÇÖÇȽº¿Í µé¾î ¹× ÀÌÀü SQL Server 2008¿¡ Æ÷ÇÔ µÈ ¸ðµç º¸¾È ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¼öÁ¤. ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔ µÈ ÃֽŠ¼öÁ¤ ¸±¸®½º¸¦ Àû¿ëÀ» °í·Á ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ ÇϽʽÿÀ.
2402659
(http://support.microsoft.com/kb/2402659/LN/ )
SQL Server 2008¿¡ SQL Server 2008 ¼­ºñ½º ÆÑ 2°¡ ¸±¸®½ºµÈ ÈÄ¿¡ ¸±¸®½ºµÈ ºôµå
ƯÁ¤ SQL Server ¼­ºñ½º ÆÑ¿¡ ´ë ÇÑ Microsoft SQL Server 2008 ÇÖÇȽº°¡ ¸¸µé¾îÁ³½À´Ï´Ù. SQL Server 2008 ¼­ºñ½º ÆÑ 2¸¦ ¼³Ä¡ ÇÏ·Á¸é SQL Server 2008 ¼­ºñ½º ÆÑ 2 ÀÌÈÄ ÇÖÇȽº¸¦ Àû¿ë ÇØ¾ß ÇÕ´Ï´Ù. ±âº»ÀûÀ¸·Î SQL Server ¼­ºñ½º ÆÑ¿¡¼­ Á¦°ø ÇÏ´Â ÇÖÇȽº´Â ´ÙÀ½ ¼­ºñ½º ÆÑ (SQL Server)¿¡ Æ÷ÇÔ µË´Ï´Ù.

SQL Server 2008 ¼­ºñ½º ÆÑ 1 ´©Àû ¾÷µ¥ÀÌÆ® 14

ÀÌ ¹®Á¦Á¡¿¡ ´ë ÇÑ ¼öÁ¤ ÇÁ·Î±×·¥Àº ¸ÕÀú SQL Server 2008 ¼­ºñ½º ÆÑ 1 ¿ë ´©Àû ¾÷µ¥ÀÌÆ® 14¿¡¼­¿¡¼­ ¸±¸®½º µÇ¾ú½À´Ï´Ù. ÀÌ ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¿¡ ´ë ÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ ÇÕ´Ï´Ù.
2527187
(http://support.microsoft.com/kb/2527187/LN/ )
SQL Server 2008 ¼­ºñ½º ÆÑ 1 ¿ë ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö 14
Âü°í ºôµå ´©Àû µÇ´Â ÇüÅ À̹ǷΠ°¢ »õ ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¸ðµç ÇÖÇȽº¿Í µé¾î ¹× ÀÌÀü SQL Server 2008¿¡ Æ÷ÇÔ µÈ ¸ðµç º¸¾È ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¼öÁ¤. ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔ µÈ ÃֽŠ¼öÁ¤ ¸±¸®½º¸¦ Àû¿ëÀ» °í·Á ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ ÇϽʽÿÀ.
970365
(http://support.microsoft.com/kb/970365/LN/ )
SQL Server 2008¿¡ SQL Server 2008 ¼­ºñ½º ÆÑ 1ÀÌ ¸±¸®½ºµÈ ÈÄ¿¡ ¸±¸®½ºµÈ ºôµå
Microsoft SQL Server 2008¿¡ ´ë ÇÑ Æ¯Á¤ SQL Server ¼­ºñ½º ÆÑ ÇÖÇȽº°¡ ¸¸µé¾îÁ³½À´Ï´Ù. SQL Server 2008 ¼­ºñ½º ÆÑ 1À» ¼³Ä¡ ÇÏ·Á¸é SQL Server 2008 ¼­ºñ½º ÆÑ 1 ÀÌÈÄ ÇÖÇȽº¸¦ Àû¿ë ÇØ¾ß ÇÕ´Ï´Ù. ±âº»ÀûÀ¸·Î SQL Server ¼­ºñ½º ÆÑ¿¡¼­ Á¦°ø ÇÏ´Â ÇÖÇȽº´Â ´ÙÀ½ ¼­ºñ½º ÆÑ (SQL Server)¿¡ Æ÷ÇÔ µË´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇöÀç »óÅÂ

Microsoft´Â "Àû¿ë ´ë»ó" Àý¿¡ ³ª¿­ µÈ Á¦Ç°¿¡¼­ ¹®Á¦°¡ ÀÖÀ½À» È®ÀÎ Çß½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

¼Ó¼º

±â¼ú ÀÚ·á: 2530921 - ¸¶Áö¸· °ËÅä: 2011³â 8¿ù 15ÀÏ ¿ù¿äÀÏ - ¼öÁ¤: 2.0
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
Å°¿öµå:?
kbqfe kbexpertiseadvanced kbsurveynew kbfix kbmt KB2530921 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù.
ÀÌ ¹®¼­ÀÇ ¿µ¹® ¹öÀü º¸±â:2530921
(http://support.microsoft.com/kb/2530921/en-us/ )
À§·Î °¡±â | Çǵå¹é º¸³»±â

Çǵå¹é º¸³»±â

 
À§·Î °¡±âÀ§·Î °¡±â