SELECT TOP 100 PERCENT CASE WHEN A.State = 'В работе' THEN CAST(A.DaysToEventEnd AS integer) ELSE '9999' END AS DaysToEventEndNewSort,
A.DirCode, A.RegistrCode, LEFT(A.LocName, 1) AS LocName, LEFT(A.MedName, 3) AS MedName, A.TypeName, A.OldType_ShortName, A.NameLS,
A.Declarant, A.DeclarantCountry, A.ExpertName, A.ExpertID, CASE WHEN A.State = 'В работе' THEN CAST(A.DaysToCentrEnd AS varchar)
ELSE '---' END AS DaysToCentrEnd, CASE WHEN A.State = 'В работе' THEN CAST(A.DaysToEventEnd AS varchar) ELSE '---' END AS DaysToEventEnd,
LEFT(A.DocType, 1) AS DocType, A.EventsQuantity, LEFT(A.ChemistryState, 1) AS ChemistryState, LEFT(A.Status, 1) AS Status, A.State,
CASE WHEN A.State = 'В работе' THEN CAST(A.DaysToEventEnd AS varchar) ELSE '---' END AS DaysToEventEndNew, B.LoginName
FROM dbo.fn_TEList_Init() A CROSS JOIN
dbo.tTEList_SO B
WHERE (B.LoginName = SUSER_SNAME()) AND (@DirCode IS NULL OR
@DirCode = 'Все' OR
A.DirCode = @DirCode) AND (@NameLS IS NULL OR
@NameLS = 'Все' OR
A.NameLS LIKE '%' + @NameLS + '%' OR
@NameLS = '-- Отсутствует --' AND A.NameLS IS NULL) AND (@Declarant IS NULL OR
@Declarant = 'Все' OR
A.Declarant LIKE '%' + @Declarant + '%' OR
@Declarant = '-- Отсутствует --' AND A.Declarant IS NULL) AND (@DeclarantCountry IS NULL OR
@DeclarantCountry = 'Все' OR
A.DeclarantCountry = @DeclarantCountry OR
@DeclarantCountry = '-- Отсутствует --' AND A.DeclarantCountry IS NULL) AND (@ExpertID IS NULL OR
@ExpertID = '-1' OR
A.ExpertID = @ExpertID OR
@ExpertID = '0' AND A.ExpertID IS NULL) AND (@DocType IS NULL OR
@DocType = 'Все' OR
A.DocType = @DocType OR
@DocType = '?? Отсутствует ??' AND A.DocType IS NULL) AND (@Status IS NULL OR
@Status = 'Все' OR
A.Status = @Status) AND (@State IS NULL OR
@State = 'Все' OR
A.State = @State)
ORDER BY DaysToEventEndNewSort

DECLARE @DirCode varchar(20), @NameLS varchar(20),  @Declarant varchar(20),  @DeclarantCountry varchar(20),  @DocType varchar(20),  @Status varchar(20),  @State varchar(20)    SET @DirCode ='Все'
 SET @NameLS ='Все'
 SET @Declarant ='Все'
 SET @DeclarantCountry ='Все'
 SET @DocType ='Все'
 SET @Status ='Все'
 SET @State ='Все'    --SET @Date = CONVERT(datetime, CONVERT(char,GETDATE(),1),1)
 SELECT     TOP 100 PERCENT CASE WHEN A.State = 'В работе' THEN CAST(A.DaysToEventEnd AS integer) ELSE '9999' END AS DaysToEventEndNewSort,                         DirCode, RegistrCode, LEFT(LocName, 1) AS LocName, LEFT(MedName, 3) AS MedName, TypeName, Ol

|--Sort(ORDER BY:([Expr1026] ASC))
       |--Compute Scalar(DEFINE:([Expr1026]=If (If (Convert([tTheoryEvents].[IsDossierReturn])=1) then 'Возврат Досье' else If (Convert([tTheoryEvents].[IsArchive])=1) then 'Архив' else If (Convert([tTheoryEvents].[IsCommission])=1) then 'Комиссия' else If
            |--Hash Match(Right Outer Join, HASH:([tExpType].[Id])=([tTheory].[TheoryTypeID_Old]), RESIDUAL:([tTheory].[TheoryTypeID_Old]=[tExpType].[Id]))
                 |--Table Scan(OBJECT:([LFFASQL].[dbo].[tExpType]))
                 |--Hash Match(Right Outer Join, HASH:([tTheoryGroupType].[Type_ID])=([tTheory].[TheoryTypeID]), RESIDUAL:([tTheory].[TheoryTypeID]=[tTheoryGroupType].[Type_ID]))
                      |--Nested Loops(Left Outer Join, OUTER REFERENCES:([tTheoryGroupType].[Type_Name]))
                      |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([tTheoryGroupType].[Type_Med_ID]))
                      |    |    |--Clustered Index Scan(OBJECT:([LFFASQL].[dbo].[tTheoryGroupType].[PK_tTheoryGroupType]))
                      |    |    |--Hash Match(Cache, HASH:([tTheoryGroupType].[Type_Med_ID]), RESIDUAL:([tTheoryGroupType].[Type_Med_ID]=[tTheoryGroupType].[Type_Med_ID]))
                      |    |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([tTheoryGroupMeds].[Med_Loc_ID]))
                      |    |              |--Clustered Index Seek(OBJECT:([LFFASQL].[dbo].[tTheoryGroupMeds].[PK_tTheoryGroupMeds]), SEEK:([tTheoryGroupMeds].[Med_ID]=[tTheoryGroupType].[Type_Med_ID]) ORDERED FORWARD)
                      |    |              |--Clustered Index Seek(OBJECT:([LFFASQL].[dbo].[tTheoryGroupLocation].[PK_tTheoryGroupLocation]), SEEK:([tTheoryGroupLocation].[Loc_ID]=[tTheoryGroupMeds].[Med_Loc_ID]) ORDERED FORWARD)
                      |    |--Clustered Index Seek(OBJECT:([LFFASQL].[dbo].[tTheoryGroupType_Names].[PK_tTheoryGroupType_Names]), SEEK:([tTheoryGroupType_Names].[TheoryType_Name]=[tTheoryGroupType].[Type_Name]) ORDERED FORWARD)
                      |--Nested Loops(Inner Join, WHERE:(([@Status]=NULL OR [@Status]='Все') OR If (Convert([tTheoryEvents].[IsDossierReturn])=1 OR Convert([tTheoryEvents].[IsCommission])=1) then 'Завершенный' else If ([tTheoryResultNames].[Rank]=1) then '
                           |--Stream Aggregate(DEFINE:([Expr1005]=MAX([tTodaysDate].[Today])))
                           |    |--Top(1)
                           |         |--Clustered Index Scan(OBJECT:([LFFASQL].[dbo].[tTodaysDate].[PK_tTodaysDate]), ORDERED BACKWARD)
                           |--Hash Match(Right Outer Join, HASH:([tTheoryResultNames].[ResultName])=([tTheoryEvents].[Result]), RESIDUAL:([tTheoryResultNames].[ResultName]=[tTheoryEvents].[Result]))
                                |--Clustered Index Scan(OBJECT:([LFFASQL].[dbo].[tTheoryResultNames].[PK_tTheoryResultNames]))
                                |--Hash Match(Right Outer Join, HASH:([tExpert].[ExID])=([tTheory].[ExID]), RESIDUAL:([tTheory].[ExID]=[tExpert].[ExID]))
                                     |--Compute Scalar(DEFINE:([tExpert].[Name]=dbo.tExpert.[LastName]+' '+substring(dbo.tExpert.[FirstName], 1, 1)+'.'+substring(dbo.tExpert.[Patronymic], 1, 1)+'.'))
                                     |    |--Clustered Index Scan(OBJECT:([LFFASQL].[dbo].[tExpert].[PK_tExpert]))
                                     |--Filter(WHERE:(((([@DocType]=NULL OR [@DocType]='Все') OR [tTheoryEvents].[DocType]=Convert([@DocType])) OR ([@DocType]='?? Отсутствует ??' AND [tTheoryEvents].[DocType]=NULL)) AND (([@State]=NULL OR [@State]='Все') O
                                          |--Merge Join(Right Outer Join, MERGE:([tTheoryEvents].[ID])=([tTheory].[CurrentEventID]), RESIDUAL:([tTheory].[CurrentEventID]=[tTheoryEvents].[ID]))
                                               |--Clustered Index Scan(OBJECT:([LFFASQL].[dbo].[tTheoryEvents].[PK_tTheoryEvents]), ORDERED FORWARD)
                                               |--Sort(ORDER BY:([tTheory].[CurrentEventID] ASC))
                                                    |--Merge Join(Inner Join, MERGE:([tTheory].[DirCode])=([tTheoryEvents].[DirCode]), RESIDUAL:([tTheory].[DirCode]=[tTheoryEvents].[DirCode]))
                                                         |--Filter(WHERE:((([@Declarant]=NULL OR [@Declarant]='Все') OR like([tTheory].[Declarant], '%'+[@Declarant]+'%', NULL)) OR ([@Declarant]='-- Отсутствует --' AND [tTheory].[Declarant]=NULL)))
                                                         |    |--Clustered Index Scan(OBJECT:([LFFASQL].[dbo].[tTheory].[PK_tTheory]),  WHERE:(((([@DirCode]=NULL OR [@DirCode]='Все') OR [tTheory].[DirCode]=[@DirCode]) AND ((([@NameLS]=NULL OR [@NameLS]='Вс
                                                         |--Sort(ORDER BY:([tTheoryEvents].[DirCode] ASC))
                                                              |--Hash Match(Aggregate, HASH:([tTheoryEvents].[DirCode]), RESIDUAL:([tTheoryEvents].[DirCode]=[tTheoryEvents].[DirCode]))
                                                                   |--Clustered Index Scan(OBJECT:([LFFASQL].[dbo].[tTheoryEvents].[PK_tTheoryEvents]))