Question

我在MS Sql Server 2008 中创建了一条支流表。我怎样才能将由此形成的支流表保存到永久的桌子上?

SELECT *
FROM (SELECT yr as [year], lname as [player], avg_rating as Rating
  FROM pool_ratings_yr1) as s
PIVOT
  (SUM(Rating) FOR [player] in (greenleaf, maturo, allen, caras, concannon, taberski, mosconi, weston, seaback, deoro, blankenship, ralph, keough, kreuter, layton, hueston, rudolph, lauri) ) AS pool_pivot

Thanks, Will

Answer 1

使用 < a href=>" "http://msdn.microsoft.com/en-us/library/ms188029%28SQL.100%29.aspx" rel="nofollow"\\code>SELECT into :

SELECT *
INTO dbo.Permanent_Table_1
FROM 
(
  SELECT yr as [year], lname as [player], avg_rating as Rating
  FROM dbo.pool_ratings_yr1
) as s
PIVOT
(
   SUM(Rating) FOR [player] in (greenleaf, maturo, allen, caras, 
      concannon, taberski, mosconi, weston, seaback, deoro, blankenship, 
      ralph, keough, kreuter, layton, hueston, rudolph, lauri) 
) AS pool_pivot;

友情链接