BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO

ALTER VIEW [dbo].[EmailSummaryView]
AS
SELECT        dbo.Emails.ID, dbo.Emails.Name, dbo.Emails.Subject, dbo.Emails.CreatedBy, dbo.Emails.CompanyID, dbo.Emails.SentOn, dbo.Emails.OpenRate, dbo.Emails.Status,
                         dbo.Emails.TotalSent, dbo.Emails.TotalOpened, dbo.Emails.TotalBounced, dbo.Emails.TotalClicked, dbo.Users.Name AS UserName, dbo.Users.Email,
                         dbo.Users.FirstName, dbo.Users.LastName, dbo.Users.CompanyName, dbo.Users.CompanyID AS UserCompanyID,
                         (case when dbo.Emails.OnBehalfOfUser = '-1' then  'Owners'
                         when dbo.Emails.OnBehalfOfUser = '-2' then  'Creators'
                         when dbo.Emails.OnBehalfOfUser is not null then (select Email from Users where ID = dbo.Emails.OnBehalfOfUser)
                         else 'Self' end ) as OnBehalf
FROM            dbo.Emails INNER JOIN
                         dbo.Users ON dbo.Emails.CreatedBy = dbo.Users.ID
WHERE        (dbo.Emails.Status = 1) AND (dbo.Users.Status = 1)

GO
COMMIT