Paul Kimmel's Blog

Another reader indicated that the PassengerManifest view was not listed in Professional DevExpress ASP.NET Controls. It should be in the TotalFlight database, but in the event that someone else needs this view here is a script that creates that view:

CREATE VIEW [dbo].[PassengerManifest]
AS
SELECT     dbo.Flight.FlightNumber, dbo.Person.LastName, dbo.Person.FirstName, dbo.Person.Title, dbo.LegManifest.Seat
FROM         dbo.LegManifest INNER JOIN
                      dbo.Person ON dbo.LegManifest.PersonID = dbo.Person.PersonID INNER JOIN
                      dbo.Leg ON dbo.LegManifest.LegID = dbo.Leg.LegID INNER JOIN
                      dbo.Flight ON dbo.Leg.FlightID = dbo.Flight.FlightID

GO