vwMDT_MEETING_DATES

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

MDT_ID

int

null

MEETING_TYPE_ID

int

null

MEETING_ID

int

√

null

MDT_DATE

smalldatetime

√

null

MEETING_TYPE_DESC

varchar

√

null

SUB_DESC

varchar

√

null

LOCATION

varchar

√

null

MDT_DESC

varchar

√

null

View Definition

CREATE VIEW [dbo].[vwMDT_MEETING_DATES]
AS
SELECT     TOP (100) PERCENT dbo.tblMDT_LIST.MDT_ID, dbo.tblMDT_MEETINGS.MEETING_TYPE_ID, dbo.tblMDT_LIST.MEETING_ID, dbo.tblMDT_LIST.MDT_DATE, 
                      dbo.ltblMDT_MEETING_TYPE.MEETING_TYPE_DESC, dbo.ltblCANCER_SUB_SITE.SUB_DESC, dbo.tblMDT_MEETINGS.LOCATION, dbo.ltblMDT_TYPE.MDT_DESC
FROM         dbo.ltblMDT_MEETING_TYPE RIGHT OUTER JOIN
                      dbo.ltblCANCER_SUB_SITE RIGHT OUTER JOIN
                      dbo.ltblMDT_TYPE RIGHT OUTER JOIN
                      dbo.tblMDT_MEETINGS INNER JOIN
                      dbo.tblMDT_LIST ON dbo.tblMDT_MEETINGS.MEETING_ID = dbo.tblMDT_LIST.MEETING_ID ON 
                      dbo.ltblMDT_TYPE.MDT_ID = dbo.tblMDT_MEETINGS.LOCAL_NETWORK ON 
                      dbo.ltblCANCER_SUB_SITE.SUB_ID = dbo.tblMDT_MEETINGS.SUB_SITE ON 
                      dbo.ltblMDT_MEETING_TYPE.MEETING_TYPE_ID = dbo.tblMDT_MEETINGS.MEETING_TYPE_ID
WHERE     (dbo.tblMDT_LIST.MDT_DATE > { fn NOW() } - 1095) AND (dbo.tblMDT_LIST.CARE_ID IS NULL)

Columns

View Definition

Possibly Referenced Tables/Views