Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Creating a View with Data from Another View

By: FYIcenter.com

(Continued from previous topic...)

Can You Create a View using Data from Another View?

Can You Create a View with Data from Another View? The answer is yes. A view can be used as a table to build other views. The tutorial exercise below shows you how to create a view using data from another view:

USE AdventureWorksLT;
GO

CREATE VIEW SalesOrderTop AS
   SELECT SalesOrderNumber, TotalDue, CompanyName
   FROM SalesOrderView 
   WHERE TotalDue > 10000.0
GO

SELECT TOP 10 * FROM SalesOrderTop;
GO
SalesOrderNumber TotalDue    CompanyName
---------------- ----------- ------------------------------
SO71780          42452.6519  Nearby Cycle Shop
SO71782          43962.7901  Professional Sales and Service
SO71783          92663.5609  Eastside Department Store
SO71784          119960.824  Action Bicycle Specialists
SO71796          63686.2708  Extreme Riding Supplies
SO71797          86222.8072  Riding Cycles
SO71832          39531.6085  Closest Bicycle Store
SO71845          45992.3665  Trailblazing Sports
SO71858          15275.1977  Thrilling Bike Tours
SO71897          14017.9083  Paints and Solvents Company

(Continued on next topic...)

1. What Are Views?
2. How To Create a View on an Existing Table?
3. How To See Existing Views?
4. How To Drop Existing Views from a Database?
5. How To Get a List of Columns in a View using "sys.columns"?
6. How To Get a List of Columns in a View using the "sp_columns" Stored Procedure?
7. How To Get a List of Columns in a View using the "sp_help" Stored Procedure?
8. How To Generate CREATE VIEW Script on an Existing View?
9. How To Get the Definition of a View Out of the SQL Server?
10. Can You Create a View with Data from Multiple Tables?
11. Can You Create a View using Data from Another View?
12. What Happens If You Delete a Table That Is Used by a View?
13. Can You Use ORDER BY When Defining a View?
14. How To Modify the Underlying Query of an Existing View?
15. Can You Insert Data into a View?
16. Can You Update Data in a View?
17. Can You Delete Data from a View?
18. How To Assign New Column Names in a View?
19. How Column Data Types Are Determined in a View?
20. How To Bind a View to the Schema of the Underlying Tables?
21. How To Create an Index on a View?