?????: ?? ????? ??? ????? ??? ????? ????? ????? ??? UNION ALL ?? SQL Server 2008 ?? ?? SQL Server 2008 R2

?????? ????????? ?????? ?????????
???? ???????: 2530921 - ??? ???????? ???? ????? ????? ??? ???????.

???? Microsoft ?????? ????????? Microsoft SQL Server 2008 Microsoft SQL Server 2008 R2 Service Pack 1 ???? ??????? ??????? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 Service Pack 1 ?? SQL Server 2008 R2 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? ????? ??????? ????? ???? ????? SQL Server 2008 ?? ?? 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)
????? ??? ????? ?? ????, ???? ? ?????????? ???????? ?? ????? ????? ????? ?????? ????? ??????? ????? ???? ??????:

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
?? ??? ?????????? ????? ????? ??? ?????? ???? ??????? ???? ??? ???? ??? ??????? ?? ???? ????.

????

??????? ??????? ????????

SQL Server 2008 R2

?? ????? ????? ??? ??????? ???? ??? ?? ??????? ???????? 9. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ? SQL Server 2008 R2? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2567713 ???? ??????? ???????? 9 ? SQL Server 2008 R2
?????? ????? ???? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ????? ?????? SQL Server 2008 R2 ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
981356 ???? SQL Server 2008 R2 ???? ?? ??????? ??? ????? SQL Server 2008 R2

SQL Server 2008 R2 Service Pack 1

???? ????? ??????? ????? ???? ??????? ?? ??????? ???????? 2 ? SQL Server 2008 R2 Service Pack 1. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2567714 ???? ??????? ????????? 2 ? SQL Server 2008 R2 Service Pack 1
?????? ????? ???? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ????? ?????? SQL Server 2008 R2 ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2567616 ???? SQL Server 2008 R2 ???? ?? ??????? ??? ????? SQL Server 2008 R2 Service Pack 1

SQL Server 2008 Service Pack 2

???? ????? ??????? ????? ???? ??????? ?? 5 ??????? ???????? ? SQL Server 2008 Service Pack 2. ????? ?? ????????? ??? ???? ??????? ????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2555408 ???? ??????? ????????? 5 ? SQL Server 2008 Service Pack 2
?????? ????? ???? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ????? ??????? SQL Server 2008 ???????. ???? Microsoft ??? ??????? ?????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2402659 ???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 2
??? ????? ????????? ??????? ? Microsoft SQL Server 2008 ??? ???? SQL Server ?????. ??? ????? ????? ???? SQL Server 2008 Service Pack 2 ??? ????? SQL Server 2008 Service Pack 2. ???? ???????? ??? ????? ?? ????? ???? ?? ????? ?? ???? ???? SQL Server ?? ???? ???? SQL Server ???????.

SQL Server 2008 ?????? service Pack 1 ??????? ???????? 14

???? ????? ??????? ????? ???? ??????? ?? ??????? ???????? 14 ? SQL Server 2008 Service Pack 1. ????? ?? ????????? ??? ???? ??????? ????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2527187 ???? ??????? ????????? 14 ? SQL Server 2008 Service Pack 1
?????? ????? ???? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ????? ??????? SQL Server 2008 ???????. ???? Microsoft ??? ??????? ?????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
970365 ???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 1
Microsoft SQL Server 2008 ????????? ??????? ??? ????? ??? ???? SQL Server ?????. ??? ????? ????? ???? SQL Server 2008 Service Pack 1 ????? SQL Server 2008 Service Pack 1. ???? ???????? ??? ????? ?? ????? ???? ?? ????? ?? ???? ???? SQL Server ?? ???? ???? SQL Server ???????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

???????

???? ???????: 2530921 - ????? ??? ??????: 15/?????/1432 - ??????: 3.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 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2530921

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com