Руководство администратора

В данном примере категория с ID=22 — это контактные лица клиентов, в ней есть ДП с ID=33, где хранится email контактного лица.

ALTER PROCEDURE [dbo].[sp_ClientsEmails]
 @UserID INT = null,
 @TaskID INT,
 @UserNameMode INT =null,
 @ShowAllTasks bit = 0,
 @StartIndex INT = null,
 @EndIndex INT = null
--@a bit=0
AS
BEGIN

; with ClientEmails as (
SELECT DISTINCT t22.ExtParam33Value as email
FROM TasksInSubcat22Denormalized t22 with (nolock)
WHERE t22.ExtParam33NativeValue = @taskid
  and t22.ExtParam33Value <> ''
)

 
SELECT
    e.DateCreated as [Дата]
    ,e.[From] as [От]
    ,e.[To] as [Кому]
    ,e.[Subject] as [Тема]
    ,e.[Textbody] as [Текст]
    ,@TaskID as [TaskID]
    ,cast(0 as bit) as [IsOverdue]
    ,1 as [StateID]
    ,1 as[PriorityID]
    ,cast(0 as bit) as [IsClosed]
    ,NULL as [IntColor]
    ,NULL as [FinishWork]
    ,NULL as [ParentTaskID]
    ,'/Emails/EmailView.aspx?folderId=' + cast(emf.FolderID as varchar(10)) + '&EmailID=' + cast(e.emailid as varchar(15)) as [href]
FROM [dbo].[EmailAddressBooks] as eb
 INNER JOIN [dbo].[EmailAddressBooksEmails] as ebe
         ON eb.EntryId = ebe.EntryId and ebe.RecipientType = 0
 INNER JOIN emails e with (nolock)
         ON e.EmailID = ebe.EmailId
 JOIN EmailMailBoxesFoldersEmails emf
         ON e.EmailID = emf.EmailId
WHERE eb.EmailAddress in (SELECT email FROM ClientEmails)
ORDER BY [Дата] desc

END