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

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

Microsoft Microsoft SQL Server 2008 Microsoft SQL ????? 2008 R2 ?????? ??? 1 ?????? ?? ??? ??? ?? ??????? ????? ?????? ???? ??? ???????? ????? ???? ???, ??????? ??? ?????????? ???????? ???? ?? ?? ?? ????? SQL Server 2008 ?????? ??? 1 ?? SQL Server 2008 R2 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ????
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ?? ??? ?? ????? UNION ??? ???????? ???? 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)
??? ????? ??? ???????? ???? TabA, TabB, ?? TabD ????????, ?? ???? ??? ????? ????? ????? 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 ????? 2008 R2

?? ?????? ?? ??? ????? ??? ????? ?????? 9 ???? ?????? ???? ??? ??? ?? ????? ?????? ????? ?? ??? SQL Server 2008 R2 ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2567713 ????? ?????? ?????? 9 SQL Server 2008 R2 ?? ???
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2008 R2 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ???? ?? ??????? ???? ??? ?? ?? ?????? ?? ???????? ????? ?????? ??? ?????? ???? ?????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
981356 SQL Server 2008 R2 ?? SQL ????? 2008 R2 ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ??

SQL ????? 2008 R2 ?????? ??? 1

?? ?????? ?? ??? ????? ???? ????? ?????? 2 ??? SQL ????? 2008 R2 ?????? ??? 1 ?? ??? ?????? ???? ??? ??? ?? ????? ?????? ?????? ?? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2567714 ????? ?????? ????? 2 SQL ????? 2008 R2 ?????? ??? 1 ?? ???
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2008 R2 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ???? ?? ??????? ???? ??? ?? ?? ?????? ?? ???????? ????? ?????? ??? ?????? ???? ?????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2567616 SQL Server 2008 R2 ?? SQL ????? 2008 R2 ?????? ??? 1 ???? ???? ?? ??? ?????? ???? ??? ?? ??

SQL Server 2008 ?????? ??? 2

?? ?????? ?? ??? ????? ???? ????? ?????? 5 ??? SQL Server 2008 ?????? ??? 2 ?? ??? ???? ???? ??? ??? ?? ????? ?????? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2555408 SQL Server 2008 ?????? ??? 2 ?? ??? ????? ?????? ?????? 5
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2008 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ???? Microsoft ??????? ???? ?? ?? ?? ???? ?????? ?? ???????? ????? ?????? ??? ?????? ?????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2402659 SQL Server 2008 ?????? ??? 2 ?? ???? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ?? SQL Server 2008
??????? SQL Server ?????? ??? ?? ??? Microsoft SQL Server 2008 ?????????? ?? ???? ???? ?? ???? SQL Server 2008 ?????? ??? 2 ?? ??????? ???? ?? ??? SQL Server 2008 ?????? ??? 2 ???????? ???? ???? ?????? ???????? ??? ??, SQL Server ?????? ??? ??? ?????? ?? ?? ???? ?? ???????? ???? SQL Server ?????? ??? ??? ????? ???

SQL ????? 2008 ?????? ??? 1 ????? ?????? 14

?? ?????? ?? ??? ????? ???? SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? 14 ??? ?????? ???? ??? ??? ?? ????? ?????? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2527187 SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? ?????? 14
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2008 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ???? Microsoft ??????? ???? ?? ?? ?? ???? ?????? ?? ???????? ????? ?????? ??? ?????? ?????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
970365 SQL Server 2008 ?????? ??? 1 ???? ???? ?? ??? ?????? ???? ??? ?? ?? ?? SQL Server 2008
Microsoft SQL Server 2008 ???????? ????? SQL Server ?????? ??? ?? ??? ???? ???? ???? ?? ???? SQL Server 2008 ?????? ??? 1 ?? ??????? ???? ?? ??? SQL Server 2008 ?????? ??? 1 ???????? ???? ???? ?????? ???????? ??? ??, SQL Server ?????? ??? ??? ?????? ?? ?? ???? ?? ???????? ???? SQL Server ?????? ??? ??? ????? ???

??????

Microsoft ?? ?????? ?? ?? ?? ?? "?? ?? ????" ???? ??? ???????? Microsoft ???????? ??? ?? ?????? ???

???

???? ID: 2530921 - ????? ???????: 15 ????? 2011 - ??????: 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 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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