spLoadRecord_EmailList

CREATE PROCEDURE [dbo].[spLoadRecord_EmailList] (
@PKID int
)
AS

declare @UploadedDataSourceID int
declare @DataSourceID int
declare @clientsID int

SELECT
[ID],
[ClientsID],
[OwnerID],
[Deleted],
[Name],
[Description],
[Guid],
[Subscription],
[type],
[DataSourceID],
[Options] ,
[AcquiredStatus],
[AcquiredDate],
[AcquiredMsg],
[AcquiredStartDate],
[AcquiredRecordCount],
[EmailDisplayNameFieldName],
[EmailAddressFieldName],
[UniqueKeyFieldName],
[UploadFileName],
[UploadFileSize],
[ListDataSchema],
[UploadedDataSourceID],
[Origin],
[UserImportID],
[BBDMListID],
[SystemList],
(SELECT [Name] FROM Chapters WHERE MemberEmailListID = @PKID) CHapterName,
[CLIENTSITESID]
FROM [dbo].[EmailList]
WHERE [ID] = @PKID


SELECT QueryID,QueryName,BBSystem FROM [dbo].EmailList_Query WHERE EmailListID = @PKID

SELECT dbo.fnEmailListIsLinked(@PKID) as LinkedEmailList

select
ep.id as EmailProjectID,
ep.Name as EmailProjectName,
epa.id as EmailProjectAppealID,
epa.Name as EmailProjectAppealName,
epael.id,
epael.emaillistid,
epael.EmailProjectAppealID,
epael.AppealListType
from dbo.EmailProjectAppeal_EmailList epael
inner join dbo.EmailProjectAppeal epa
on epa.id = epael.EmailProjectAppealID
inner join dbo.EmailProject ep
on epa.EmailProjectID = ep.id
where epael.emaillistid=@PKID


select
@UploadedDataSourceID = UploadedDataSourceID,
@DataSourceID = datasourceID,
@clientsID = clientsid
FROM [dbo].[EmailList]
WHERE [ID] = @PKID

declare @IdToUse int

if (coalesce(@UploadedDataSourceID,0) > 0) begin
set @IdToUse=@UploadedDataSourceID
end
else
begin
set @IdToUse=@DataSourceID
end

exec dbo.spGetEmailTemplatesForDataSource @clientsID, @IdToUse, 0