select  A.IdElements, A.IdElements, U.IdEmployee, U.IdPost, U.IdStructureLR, D.DateDay, G.FirstQuantityHour+G.SecondQuantityHour+G.ThirdQuantityHour, G.FirstQuantityHour+G.SecondQuantityHour+G.ThirdQuantityHour,
       D.IdFirstTypeDay, D.IdSecondTypeDay, D.IdThirdTypeDay, D.IdFourthTypeDay,
       D.FirstQuantityHour, D.SecondQuantityHour, D.ThirdQuantityHour, D.FourthQuantityHour,        
       U.SignBasis, U.SortNotBasis, U.IdGraphWork, U.PercentSalary,U.AddQuantityHour,
       P.TypeSalary, U.SignBasisCategory, U.TypeMove, AAA=1
 from StructureLR A
 inner join ViewTableWorkEmployee U on A.IdStructureLR = U.IdStructureLR and U.IdTableWorkType = 0 and U.IdMonth between month(@SDate) and month(@FDate) and U.TheYear between year(@SDate) and year(@FDate)
 inner join DetailsTableWork D on D.IdEmployee = U.IdEmployee and D.IdStructureLR = U.IdStructureLR and D.IdTableWork = U.IdTableWork
 inner join GraphWorkDetails G on U.IdGraphWork = G.IdGraphWork and G.DateDay = D.DateDay
 inner join Employee S on D.IdEmployee = S.IdEmployee
 inner join Post P on U.IdPost = P.IdPost
 where A.Lft between @IdLft and @IdRght and
       A.Rght between @IdLft and @IdRght
OPTION(RECOMPILE)