V_QUERY_EMAILFINDERBATCHCONTROLREPORT

View used for output for the EmailFinder batch control report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(154)	yes	Name
EMAILADDRESS	UDT_EMAILADDRESS		Email

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:59 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_EMAILFINDERBATCHCONTROLREPORT AS



                select 
                    EMAILADDRESS.ID,
                    CONSTITUENT.NAME,
                    EMAILADDRESS.EMAILADDRESS
                from 
                    dbo.EMAILADDRESS
                inner join
                    dbo.CONSTITUENT on EMAILADDRESS.CONSTITUENTID = CONSTITUENT.ID