Page Comparison

...

MBV Display Name: EventInformation
View: EventInfo
Fields:

CREATE VIEW [dbo].vwEventInformations
AS
SELECT 
    m.ID  'ID',
    m.MeetingTitle  'EventName',


   
m.StartDate  'StartDate',


   
m.EndDate  'EndDate', 


   
e.FirstLast  'PlannerName', 


   
CASE WHEN e.WorkAreaCode IS NULL THEN  e.WorkPhone else '(' + e.WorkAreaCode + ')' + e.WorkPhone end   'PlannerPhone',  


   
e.HomeFax  'PlannerFax', 


   
e.WebPage  'PlannerURL', 


   
e.Email1  'PlannerEmail', 


   
e.FirstLast  'PlannerContactName', 


   
m1.MeetingID  'MeetingID',


   
m.VerboseDescription  'Description', 


   
p.WebProductPage  'Website'


FROM 


   
Meeting m


   
LEFT OUTER JOIN 


       
vwEmployees    e 


       
ON 


            m.CoordinatorID=e.ID


   
LEFT OUTER JOIN 


       
vwMeetings    m1 


       
ON 


            m.ID=m1.ID


   
LEFT OUTER JOIN 


       
Product    p 


       
ON 


            m.ProductID=p.ID 

Anchor
_location _location

Event Location

MBV Display Name: EventLocation
View: EventLocation
Fields:

Anchor
_rooms _rooms

Event Rooms

MBV Display Name: Room
View: EventRooms
Fields:

Anchor
_agenda _agenda

Event Agenda

MBV Display Name: EventSessions
View: EventSessions
Fields:

Anchor
_sponsors _sponsors

Event Sponsors

MBV Display Name: Sponsors
View: EventSponsors
Fields:

Anchor
_attendees _attendees

Event Attendees

MBV Display Name: Attendees
View: EventAttendees
Fields:

Anchor
_exhibit _exhibit

Event Exhibitors

MBV Display Name: Exhibitor
View: EventExhibitors
Fields:

Anchor
_speakers _speakers

Event Speakers

MBV Display Name: Speakers
View: EventSpeakers
Fields:

Anchor
_sessions _sessions

Event Sessions

MBV Display Name: Sessions
View: EventSessions
Fields:

Anchor
_genInfo _genInfo

Event General Information

MBV Display Name: GeneralInfo
View: EventGeneralInfo
Fields:

Anchor
_tracks _tracks

Event Tracks

...